A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HELP! Two excel windows



 
 
Thread Tools Display Modes
  #1  
Old September 21st, 2006, 05:02 PM posted to microsoft.public.excel.setup
Veronica
external usenet poster
 
Posts: 54
Default 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????

  #2  
Old September 21st, 2006, 07:48 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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
  #3  
Old September 21st, 2006, 08:04 PM posted to microsoft.public.excel.setup
Veronica
external usenet poster
 
Posts: 54
Default 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

  #4  
Old September 21st, 2006, 08:56 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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
  #5  
Old September 21st, 2006, 09:06 PM posted to microsoft.public.excel.setup
Veronica
external usenet poster
 
Posts: 54
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.