Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Location: Waskom, TX
Posts: 4
Question Default Book1 on opening Excel 2002

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   Report Post  
Junior Member
 
Location: Waskom, TX
Posts: 4
Default

Quote:
Originally Posted by campingshadow View Post
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?

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
Search this Thread:

Advanced Search
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
Excel continues a loop to ask to save default file, book1 Kollin Excel Discussion (Misc queries) 2 February 21st 06 01:35 PM
when opening an excel file, 2 files open (one is book1)? Brian Excel Discussion (Misc queries) 1 December 10th 05 12:53 AM
Stop Opening Book1! dpcarlton Excel Discussion (Misc queries) 4 December 5th 05 06:12 PM
Excel 2K3: Opening a spreadsheet, also opens book1.xls? Newtek Excel Discussion (Misc queries) 3 July 6th 05 08:56 PM
Excel 2K3: Opening spreadsheet, also opens book1.xls? Newtek Setting up and Configuration of Excel 1 July 6th 05 08:56 PM


All times are GMT +1. The time now is 07:39 AM.

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

About Us

"It's about Microsoft Excel"