Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Roger uses Excel 2007. Every time he starts the program, it is supposed to open a blank worksheet. However, Roger notes that Excel always opens Personal.xlsb instead of a fresh worksheet.
The Personal.xlsb worksheet (and its predecessor Personal.xls worksheets in earlier versions of Excel) is used, most often, to contain macros that you want available whenever you are using Excel. Normally the worksheet is hidden, unless it has been specifically unhidden and Excel saved.
To solve the problem, just start Excel and when the Personal.xlsb file is visible, display the View tab of the ribbon and click Hide in the Window group. The worksheet goes away, and you should immediately exit Excel. (If you are asked if you want to save your changes, respond in the affirmative.)
The next time you start Excel, you should no longer see Personal.xlsb because it is hidden. Instead you should see a regular blank worksheet, exactly as you expect.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3290) applies to Microsoft Excel versions: 2007
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.