opens an extra workbook

[Guest]

Everytime I open any of my Excel files it now opens an additional (and
unwanted) workbook. It never used to do this, how do I stop this from
happening?
Thanks,
Joanne

 

[Ron de Bruin]

Hi Joanne

Maybe this ?
http://www.contextures.com/xlfaqApp.html#TwoWindows

 

[Guest]

Thanks Ron, but unfortunately that is not it. When I open the file I get the
workbook I want and then a second blank workbook labelled "book 1". I have
tried the close and save suggestion but it still opens a blank "book 1" again
the next time I open the file.

Joanne

 

[Gord Dibben]

A blank book or a particular book?


Gord Dibben MS Excel MVP

 

[Guest]

A blank one.
Joanne

A blank book or a particular book?


Gord Dibben MS Excel MVP

 

[Gord Dibben]

What does your command line look like in Folder Options>File Types?

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

 

[Guest]

That is exactly what I have. Any other suggestions?
Joanne

What does your command line look like in Folder Options>File Types?

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

A blank one.
Joanne

 

[Dave Peterson]

What do you have in your XLStart folder?
(Use windows|search to find that folder)

and if you open excel and see that extra workbook, put this in A1 of the first
worksheet:

=cell("Filename",a1)
(don't change anything in that formula)

What do you see?

 

[Guest]

In the XLStart folder I have only one file and it is a pdf maker 5.0 macro
for Excel
When I enter that formula in A1 of the extra book nothing appears in the cell.
Joanne.

 

[Dave Peterson]

If you've upgraded through different versions of excel, you could have multiple
XLStart folders. Any chance you've done that?

If yes, look again through all the XLStart folders.

===
Since the formula returned nothing, that means that there isn't an existing .xls
workbook opening. But the challenge is still to find the cause.