Open a workbook also opens "Book1.xls"

  • Thread starter Thread starter Oscar W
  • Start date Start date
O

Oscar W

Hi all,

I wonder if it is possible to stop Excel from opening a copy of
"Book1.xls" everytime a workbook is opened. (I.e. I just want to open
the required workbook, not simultaneously open a copy of "Book1.xls"
as well).

Thanks,
Oscar
 
Not sure what you mean. When I double-click on an XLS file in
Windows Explorer, book1 doesn't open, only the requested workbook.
If you want to start Excel without opening a workbook, try the /E
switch. For example:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e


HTH,
JP
 
If the file is really named book1.xls (not book1 without an extension), then I'd
close excel and use windows start button|search to find book1.xls and then
delete it (or move it).
 
To clarify my question/problem:

When I double click on any Excel file in Explorer, Excel first opens a
new, empty workbook (called Book1 - the normal empty workbook) and
then also opens the workbook that I actually double clicked on.

(I don't have anything in my XLStart folders, so that is not the
problem).

Thanks,
Oscar
 
Check Tools>Options, General tab, "At startup, open all files in", is
there anything there?

--JP
 
Depending on your Excel upgrade path, you may have more than one XLStart folder.

I'd use windows start button|search to look through all XLStart folders.

You may have files in a folder you didn't know about.
 
I'd follow Dave's suggestions.

Try to find that file and/or folder(s) using Windows search.


HTH,
JP
 
Oscar

Try this.................

Go to Start>Settings>Control Panel>Folder Options>File Types

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space>/e prevents a new blank book from
opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben MS Excel MVP
 
Oscar

Try this.................

Go to Start>Settings>Control Panel>Folder Options>File Types

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\EXCEL.EXE" /e

You must have the double quotes and the <space>/e prevents a new blank book from
opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben  MS Excel MVP

To clarify my question/problem:
Click to expand...
When I double click on any Excel file in Explorer, Excel first opens a
new, empty workbook (called Book1 - the normal empty workbook) and
then also opens the workbook that I actually double clicked on.
Click to expand...
(I don't have anything in my XLStart folders, so that is not the
problem).
Click to expand...

- Show quoted text -
Click to expand...

Hehe Oscar...

Hi guys, I experience the same thing as Oscar does and I have the
settings as Gord presented. Any other guesses?

Regards,
 
Did you look for multiple XLStart folders?
Hehe Oscar...

Hi guys, I experience the same thing as Oscar does and I have the
settings as Gord presented. Any other guesses?

Regards,
Click to expand...
 
Did you see Dave's post? Do a Windows search for the book, and for
multiple XLSTART folders.


HTH,
--JP
 
Did you see Dave's post? Do a Windows search for the book, and for
multiple XLSTART folders.

HTH,
--JP





- Show quoted text -
Click to expand...

JP and Dave,

Yes, but I only have one XLStart folder. Any other guesses what could
cause it? I
 
Did you close the workbook, then close and restart Excel and see if it
happens again?


Sorry, can't think of anything else.

--JP
 
Did you close the workbook, then close and restart Excel and see if it
happens again?

Sorry, can't think of anything else.

--JP




- Show quoted text -
Click to expand...

Yeah have even rebooted the computer, but it is still the same.
Perhaps have to wait till I upgrade to the next software (have xl
2003). :)
 
Not trying to be too irritating. But if you upgraded to xl2003 from other
versions, you may want to look again for multiple XLStart folders.

How did you search for it/them?
 
JP, Dave & Wesslan,

I found that the problem is caused by an Add-In that both Wesslan & I
have.
If it is disabled, Excel can open only one workbook!

Thanks for your efforts!

Best,
Oscar
 
The add-in was provided by our employer, to automate creation of
certain graphs etc.
It was initiated via Tools | Add-Ins.
 
Ah. Thanks for the info.

Sometimes, it's good for google to know if it's a commercial addin. Then the
next victims may have it a bit easier to find answers.
 
Back
Top