bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Macros > Managing Macros > Opening Personal.xlsb in Excel 2007

Opening Personal.xlsb in Excel 2007

Summary: If you start up Excel 2007 and all you see is your Personal.xlsb file, then you may wonder what you are doing wrong. The answer is nothing—all you need to do is make sure that the file is hidden, as discussed in this tip. (This tip works with Microsoft Excel 2007.)

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.

Tip #3290 applies to Microsoft Excel versions: 2007


Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
 
Check out ExcelTips Premium today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)