Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Stop "Book1" from opening from a saved file

Hopefully, the experts can help.

Everytime I open an excel file, it opens two instances. One is "Book1",
which is blank. The other is the document I want. How do I stop the "Book
1" from opening and only get the file I requested? This just started
recently. I am using Office 2003.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Stop "Book1" from opening from a saved file

How are you opening the file? Double-clicking?

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 11:40:00 -0700, jcutolo
wrote:

Hopefully, the experts can help.

Everytime I open an excel file, it opens two instances. One is "Book1",
which is blank. The other is the document I want. How do I stop the "Book
1" from opening and only get the file I requested? This just started
recently. I am using Office 2003.

Thanks!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 95
Default Stop "Book1" from opening from a saved file

two options:
look under Tools/Options/General to check if you have entered anything in
"alternate startup file location" which in general must be blank. Here you
can specify files to autoload at every startup

Second, do you get a macro warning when you start up? If so, you might have
something hidden in the Workbook macro's.



"jcutolo" wrote:

Hopefully, the experts can help.

Everytime I open an excel file, it opens two instances. One is "Book1",
which is blank. The other is the document I want. How do I stop the "Book
1" from opening and only get the file I requested? This just started
recently. I am using Office 2003.

Thanks!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Stop "Book1" from opening from a saved file

I have tried the usual fixes..but still will not stop it from happening.

"rdwj" wrote:

two options:
look under Tools/Options/General to check if you have entered anything in
"alternate startup file location" which in general must be blank. Here you
can specify files to autoload at every startup

Second, do you get a macro warning when you start up? If so, you might have
something hidden in the Workbook macro's.



"jcutolo" wrote:

Hopefully, the experts can help.

Everytime I open an excel file, it opens two instances. One is "Book1",
which is blank. The other is the document I want. How do I stop the "Book
1" from opening and only get the file I requested? This just started
recently. I am using Office 2003.

Thanks!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Stop "Book1" from opening from a saved file

Gord,

I tried to do this, it seem to process correctly, but I still get the same
thing when I open the file.

"Gord Dibben" wrote:

How are you opening the file? Double-clicking?

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 11:40:00 -0700, jcutolo
wrote:

Hopefully, the experts can help.

Everytime I open an excel file, it opens two instances. One is "Book1",
which is blank. The other is the document I want. How do I stop the "Book
1" from opening and only get the file I requested? This just started
recently. I am using Office 2003.

Thanks!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solution "Your changes could not be saved" "The document may be read-only or encrypted" [email protected] Excel Discussion (Misc queries) 0 August 7th 06 06:31 AM
Need to link excel "cell" to a pre saved PDF file?? How do I do th Redbobber Excel Worksheet Functions 1 April 11th 06 05:20 PM
Do not allow a file to be saved if "ERROR" is in any field pmms Excel Discussion (Misc queries) 1 November 29th 05 11:39 PM
.csv drops "0" when saved, even if file was set as "text". TRminator Excel Discussion (Misc queries) 3 November 2nd 05 03:11 PM
where can I find an excel file I "saved as" in OLKE9? OOVAVOO New Users to Excel 2 October 18th 05 05:15 PM


All times are GMT +1. The time now is 11:35 PM.

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

About Us

"It's about Microsoft Excel"