Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old October 24th 05, 05:29 PM
Denver
 
Posts: n/a
Default Why does Excel open a blank book1.xls also?

When I open a workbook by double clicking the workbook in a directory, Excel
opens a blank workbook named Book1.xls. How can I prevent this from
happening?

  #2   Report Post  
Old October 24th 05, 05:42 PM
Dave Peterson
 
Posts: n/a
Default Why does Excel open a blank book1.xls also?

If that workbook is really named book1.xls, look in your XLStart folder for
Book1.xls.

And check tools|options|General tab
There's a box that allows you to specify a folder:
"At startup, open all files in:"

Either delete the entry from that box or remove book1.xls from that folder.

ps. If you can't find book1.xls this way, maybe you could use
windows start button|search and look for book1.xls
to locate that file (and folder).


Denver wrote:

When I open a workbook by double clicking the workbook in a directory, Excel
opens a blank workbook named Book1.xls. How can I prevent this from
happening?


--

Dave Peterson
  #3   Report Post  
Old October 24th 05, 05:52 PM
Gord Dibben
 
Posts: n/a
Default Why does Excel open a blank book1.xls also?

Denver

Try the usual fix(es).

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.

One more thing to try if any of the above brings no joy.........

Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit select "Open" and Edit.

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\OFFICE\EXCEL.EXE" /e (delete the <sp/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben Excel MVP

On Mon, 24 Oct 2005 09:29:02 -0700, Denver
wrote:

When I open a workbook by double clicking the workbook in a directory, Excel
opens a blank workbook named Book1.xls. How can I prevent this from
happening?




Reply
Thread Tools
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
Click on Excel Doc Starts Excel but Excel does not Open the Doc. Mark Excel Discussion (Misc queries) 3 August 24th 05 02:33 PM
How do I open a Quattro Pro 7.0 file in Excel 2003 cpatrick83 Excel Discussion (Misc queries) 0 August 22nd 05 09:41 PM
trying to open an excel file in excel 2003 Edward Letendre Excel Discussion (Misc queries) 1 June 3rd 05 02:22 PM
Excel won't open - pasting from Access Rebecca Excel Discussion (Misc queries) 0 May 25th 05 12:15 AM
existing excel file when clicked opens blank excel document snows_24 Excel Discussion (Misc queries) 1 May 21st 05 07:15 PM


All times are GMT +1. The time now is 12:10 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017