Stop Opening Book1!

Hi,

I know this is possible, but forgotten how to do it. I want Excel to stop opening book1.xls when I open another workbooks.

I know you can use the switch /e in the shortcut, but that only works when opening Excel using that shortcut.

I want Excel to stop opening book1.xls (the default) when I open any workbook.

Thanks,

Dan

If you're really opening book1.xls (with the .xls extension), look for that
book1.xls in your XLStart folder (and move it/delete it).

But the only way I know of to stop book1 (without the .xls extension) from
opening is to use the /e option.

dpcarlton wrote:
>
> Hi,
>
> I know this is possible, but forgotten how to do it. I want Excel to
> stop opening book1.xls when I open another workbooks.
>
> I know you can use the switch /e in the shortcut, but that only works
> when opening Excel using that shortcut.
>
> I want Excel to stop opening book1.xls (the default) when I open any
> workbook.
>
> Thanks,
>
> Dan
>
> --
> dpcarlton
> ------------------------------------------------------------------------
> dpcarlton's Profile: http://www.excelforum.com/member.php...o&userid=29364
> View this thread: http://www.excelforum.com/showthread...hreadid=490755

--

Dave Peterson

Thanks for the reply, but unfortunately it does not help.

It does not exist in the XLSTART folder, I wish it was that easy. It has always been an issue with Excel, where it opens up a blank workbook on start, and Book1.xls just happens to be the name is choses.

If I remember correctly, it was a registry setting required to fix this.

Maybe it's in a different xlstart folder

Windows start button|search
for book1.xls



dpcarlton wrote:
>
> Thanks for the reply, but unfortunately it does not help.
>
> It does not exist in the XLSTART folder, I wish it was that easy. It
> has always been an issue with Excel, where it opens up a blank workbook
> on start, and Book1.xls just happens to be the name is choses.
>
> If I remember correctly, it was a registry setting required to fix
> this.
>
> --
> dpcarlton
> ------------------------------------------------------------------------
> dpcarlton's Profile: http://www.excelforum.com/member.php...o&userid=29364
> View this thread: http://www.excelforum.com/showthread...hreadid=490755

--

Dave Peterson

Go to Start>Settings>Folder>Options>File 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">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\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, 5 Dec 2005 10:19:57 -0600, dpcarlton
<dpcarlton.1zkrrb_1133799601.4011@excelforum-nospam.com> wrote:

>
>Thanks for the reply, but unfortunately it does not help.
>
>It does not exist in the XLSTART folder, I wish it was that easy. It
>has always been an issue with Excel, where it opens up a blank workbook
>on start, and Book1.xls just happens to be the name is choses.
>
>If I remember correctly, it was a registry setting required to fix
>this.