ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does Excel open a blank book1.xls also? (https://www.excelbanter.com/excel-discussion-misc-queries/51940-why-does-excel-open-blank-book1-xls-also.html)

Denver

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?

Dave Peterson

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

Gord Dibben

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?




All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com