HELP! Two excel windows Veronica 21.09.2006 16:02:01 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????

Re: HELP! Two excel windows Gord Dibben <gorddibbATshawDOTca> 21.09.2006 18:48:00 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 <Veronica[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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

Re: HELP! Two excel windows Veronica 21.09.2006 19:04:02 I checked all those settings and mine are set exactly as you stated. Any other ideas??? "Gord Dibben" wrote: [Quoted Text] > 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 > <Veronica[ at ]discussions.microsoft.com> wrote: > > >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 >

Re: HELP! Two excel windows Gord Dibben <gorddibbATshawDOTca> 21.09.2006 19:56:21 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 On Thu, 21 Sep 2006 12:04:02 -0700, Veronica <Veronica[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I checked all those settings and mine are set exactly as you stated. Any >other ideas??? > > >"Gord Dibben" wrote: > >> 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 >> <Veronica[ at ]discussions.microsoft.com> wrote: >> >> >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

Re: HELP! Two excel windows Veronica 21.09.2006 20:06:01 Tried those, looked ok. Still not sure. thanks for all your help so far though! "Gord Dibben" wrote: [Quoted Text] > 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 > > On Thu, 21 Sep 2006 12:04:02 -0700, Veronica > <Veronica[ at ]discussions.microsoft.com> wrote: > > >I checked all those settings and mine are set exactly as you stated. Any > >other ideas??? > > > > > >"Gord Dibben" wrote: > > > >> 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 > >> <Veronica[ at ]discussions.microsoft.com> wrote: > >> > >> >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 >