#1
|
|||
|
|||
unwanted sheets on opening excel
hi,
When i open excel i seem to get at least 3 other previous work sheets as well, I have tried a few things but cant get rid of them on the start up. any suggestions? |
#2
|
|||
|
|||
Do you mean 3 extra blank worksheets or 3 worksheets with data already in them?
For 3 extra blank worksheets Goto: Tools >> Options >> General (Tab) and then enter the number of sheets you would like in a new workbook next to 'Sheets in new workbook' Let me know if this is not what you require and I'll let you know how to fix it |
#3
|
|||
|
|||
other sheets attaching themselvesto new Excel spread sheet
Craig,
Thanks for the reply, however it is sheets of data that I have previously written that are attaching themselves to my new Excel sheets. I suspect it might be something to do with the auto recovery feature - but this is only a guess. It happens whenever I open a new Excel worksheet. Many thanks |
#4
|
|||
|
|||
The first thing I would check is a template called Book.xlt. It is stored in an XLstart folder. This folder is normally hidden and stored in various locations depending on the users login and operating system. So you will need show hidden files and then do a search to find the XLstart folder. You can open this file (as a template) and then edit it to get rid the extra worksheets/data you don't need or you could delete it entirely. This should fix your problem. Let me know how you go.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
Movement slide with excel sheets | majed | PowerPoint | 4 | 01-17-2009 04:24 PM |
Trick to restrict opening excel/word ?? | 9morebusy | Excel | 0 | 11-12-2008 04:18 AM |
Unwanted Emails | noelma | Outlook | 0 | 09-13-2008 02:28 AM |
Outlook XP *.msg opening error msg | slmka | Outlook | 0 | 06-27-2007 09:00 PM |