by Allen Wyatt
(last updated August 15, 2015)
Every time Roger starts Excel, 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 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 (6205) applies to Microsoft Excel 2007, 2010, and 2013.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
If you leave your Personal.xlsb workbook visible from one Excel session to another, you may find that you unwittingly make ...Discover More
The Personal workbook is special; it is where you can store macros you want to use all the time in Excel. What do you do, ...Discover More
Need to move a macro out of your Personal.xlsb workbook and into a regular workbook? You can do it using familiar editing ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.