Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
PROBLEM SOLVED 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.
I have read replies to the same question by others (just found those today).....and they say to make sure Excel opens with /e which mine already does. I have also deleted Book1 from the XLSTART folder and have nothing in the Tools Options for files to open at startup. Anyone have any other clues? Last edited by campingshadow : April 18th 07 at 06:54 AM |
#2
![]() |
|||
|
|||
![]() Quote:
Well, no one answered me here.....but I did find the answer to the problem and thought I would post it to help others that might have the same problem. Book1 is contained in the XLSTART folder. Problem is......I have TWO of those folders. In two different locations. I had deleted it from one folder, but not the other. Here are the locations where the XLSTART folder can be found. C:\Documents and Settings\*my name*\Application 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. Last edited by campingshadow : April 18th 07 at 06:53 AM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel continues a loop to ask to save default file, book1 | Excel Discussion (Misc queries) | |||
when opening an excel file, 2 files open (one is book1)? | Excel Discussion (Misc queries) | |||
Stop Opening Book1! | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel |