HELP! Two excel windows
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???? |
HELP! Two excel windows
Sounds like SmartView changed your command line for excel.exe
Close Excel first and On the Windows Taskbar StartRun ""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 StartSettingsFolderOptionsFile Types. If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. 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 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 |
HELP! Two excel windows
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 StartRun ""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 StartSettingsFolderOptionsFile Types. If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. 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 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 |
HELP! Two excel windows
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 ToolsOptionsGeneral and remove any path in "Alternate startup file location" Gord On Thu, 21 Sep 2006 12:04:02 -0700, Veronica 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 StartRun ""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 StartSettingsFolderOptionsFile Types. If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. 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 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 |
HELP! Two excel windows
Tried those, looked ok. Still not sure. thanks for all your help so far though!
"Gord Dibben" wrote: 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 ToolsOptionsGeneral and remove any path in "Alternate startup file location" Gord On Thu, 21 Sep 2006 12:04:02 -0700, Veronica 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 StartRun ""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 StartSettingsFolderOptionsFile Types. If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit. 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 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 |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com