Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-16-2009, 02:09 AM
Novice
 
Join Date: Feb 2009
Posts: 3
msofficeman is on a distinguished road
Smile 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?
Reply With Quote
  #2  
Old 02-20-2009, 03:12 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 02-24-2009, 06:50 AM
Novice
 
Join Date: Feb 2009
Posts: 3
msofficeman is on a distinguished road
Default 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
Reply With Quote
  #4  
Old 02-24-2009, 03:13 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default

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.
Reply With Quote
Reply

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


All times are GMT -7. The time now is 07:56 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft