Default Book1 on opening Excel 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

campingshadow - 15 Apr 2007 04:01 GMT

When opening Excel 2002 the default workbook is Book1. But if I open a
saved workbook (such as Expenses), Excel opens that workbook to the
correct sheet - BUT ALSO opens a second window for Book1. Is there a
way to change the settings so it will not open a blank Book1 when I am
opening a saved workbook? That unneeded Book1 tab just clutters up my
task bar.

Signature

campingshadow

Reply to this Message

campingshadow - 17 Apr 2007 16:33 GMT

campingshadow;480521 Wrote:

> When opening Excel 2002 the default workbook is Book1. But if I open
> saved workbook (such as Expenses), Excel opens that workbook to th
[quoted text clipped - 8 lines]
> have nothing in the Tools Options for files to open at startup. Anyon
> have any other clues?

Well, no one answered me here.....but I did find the answer to th
problem and thought I would post it to help others that might have th
same problem.

Book1 is contained in the XLSTART folder. Problem is......I have TW
of those folders. In two different locations. I had deleted it fro
one folder, but not the other.

Here are the locations where the XLSTART folder can be found.

C:\Documents and Settings\*my name*\Applicatio
Data\Microsoft\Excel\XLSTART
This is the correct folder to use.

C:\Programs\Microsoft Office\Office10\XLSTART
This ALSO had a Book1 in it.

Book 1 was removed from both locations and now Excel opens properly.

Hope this helps someone else

--
campingshadow

Reply to this Message