Excel opens two workbooks



Using Excel 2003, Win XP. Have a user who opens an Excel document, but the
first document that comes up as Book 2 and behind that is the original
document. I closed Book 2 and saved the document. Opened the document back
up and it was fine.

Now if he opens another Excel document that has the same issues, doing the
same thing as above does not fix this document. Now, if I go back and open
the first document that was fixed earlier, it is back to opening the two
documents again.

Does anyone have any other ideas? Thanks.


When the second workbook opens choose Windows->Hide and see if the problem
goes away...

Try to find the XLSTART directory. It usually is in
C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART

where <username> needs to be substituted with the current user name.
If you see the file which open automatically there then delete it while
Excel is closed.


This did not fix the problem. There was no file in this folder. I did try
and remove the Excel registry key at CU\Software\Microsoft\Office 11\Excel.
This didn't work either. Any other suggestions?

Gord Dibben

Append a /e to your Excel startup command to prevent Book1 from opening.

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....


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question