HELP! Two excel windows

[Guest]

I recently installed Hyperion Smartview and ever since then, every time I
open an excel worksheet (whether or not it is linked to smartview) an extra
worksheet (book1) opens! It isn't affecting excel at all, but it is quite
irritating because everytime I save the sheet I am using and close it, it
asks if I want to save book1.
Any ideas as to how to prevent that extra window from opening????

 

[Gord Dibben]

Sounds like SmartView changed your command line for excel.exe

Close Excel first and On the Windows Taskbar

Start>Run ""C:\program files\microsoft office\office11\excel.exe /regserver"(no
quotes)>OK.

See the space between exe and /regserver

If no joy with the above......................

Go to Start>Settings>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 a space before the /e.

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

I recently installed Hyperion Smartview and ever since then, every time I
open an excel worksheet (whether or not it is linked to smartview) an extra
worksheet (book1) opens! It isn't affecting excel at all, but it is quite
irritating because everytime I save the sheet I am using and close it, it
asks if I want to save book1.
Any ideas as to how to prevent that extra window from opening????

Gord Dibben MS Excel MVP

 

[Guest]

I checked all those settings and mine are set exactly as you stated. Any
other ideas???

Sounds like SmartView changed your command line for excel.exe

Close Excel first and On the Windows Taskbar

Start>Run ""C:\program files\microsoft office\office11\excel.exe /regserver"(no
quotes)>OK.

See the space between exe and /regserver

If no joy with the above......................

Go to Start>Settings>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 a space before the /e.

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

I recently installed Hyperion Smartview and ever since then, every time I
open an excel worksheet (whether or not it is linked to smartview) an extra
worksheet (book1) opens! It isn't affecting excel at all, but it is quite
irritating because everytime I save the sheet I am using and close it, it
asks if I want to save book1.
Any ideas as to how to prevent that extra window from opening????

Gord Dibben MS Excel MVP

 

[Gord Dibben]

Have a look in your XLSTART folder for a Book.xls

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

If anything there, move it out of that folder.

Also go into Tools>Options>General and remove any path in "Alternate startup
file location"


Gord

I checked all those settings and mine are set exactly as you stated. Any
other ideas???

Sounds like SmartView changed your command line for excel.exe

Close Excel first and On the Windows Taskbar

Start>Run ""C:\program files\microsoft office\office11\excel.exe /regserver"(no
quotes)>OK.

See the space between exe and /regserver

If no joy with the above......................

Go to Start>Settings>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 a space before the /e.

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

I recently installed Hyperion Smartview and ever since then, every time I
open an excel worksheet (whether or not it is linked to smartview) an extra
worksheet (book1) opens! It isn't affecting excel at all, but it is quite
irritating because everytime I save the sheet I am using and close it, it
asks if I want to save book1.
Any ideas as to how to prevent that extra window from opening????

Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP

 

[Guest]

Tried those, looked ok. Still not sure. thanks for all your help so far though!

Have a look in your XLSTART folder for a Book.xls

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

If anything there, move it out of that folder.

Also go into Tools>Options>General and remove any path in "Alternate startup
file location"


Gord

I checked all those settings and mine are set exactly as you stated. Any
other ideas???

Sounds like SmartView changed your command line for excel.exe

Close Excel first and On the Windows Taskbar

Start>Run ""C:\program files\microsoft office\office11\excel.exe /regserver"(no
quotes)>OK.

See the space between exe and /regserver

If no joy with the above......................

Go to Start>Settings>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 a space before the /e.

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

On Thu, 21 Sep 2006 09:02:01 -0700, Veronica

I recently installed Hyperion Smartview and ever since then, every time I
open an excel worksheet (whether or not it is linked to smartview) an extra
worksheet (book1) opens! It isn't affecting excel at all, but it is quite
irritating because everytime I save the sheet I am using and close it, it
asks if I want to save book1.
Any ideas as to how to prevent that extra window from opening????

Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP