HELP! Two excel windows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Veronica - 21 Sep 2006 17:02 GMT

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

Reply to this Message

Gord Dibben - 21 Sep 2006 19:48 GMT

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

Reply to this Message

Veronica - 21 Sep 2006 20:04 GMT

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
>
[quoted text clipped - 31 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

Gord Dibben - 21 Sep 2006 20:56 GMT

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???
[quoted text clipped - 34 lines]
>>
>> Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP

Reply to this Message

Veronica - 21 Sep 2006 21:06 GMT

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
>
[quoted text clipped - 47 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message