Personal.xlsb

The Personal workbook is where Excel stores information you will be able to access later in all your workbooks. It is important to understand how to save content with the proper workbook in Excel. The following articles discuss how to save content to the Personal workbook for later use.

Tips, Tricks, and Answers

The following articles are available for the 'Personal.xlsb' topic. Click the article''s title (shown in bold) to see the associated article.

   Automatically Hiding the Personal Workbook
If you leave your Personal.xlsb workbook visible from one Excel session to another, you may find that you unwittingly make changes you never intended to make. Here's some ideas on how to protect the workbook or at least stop yourself from making those unwanted changes.

   Moving Macros from the Personal Workbook
Need to move a macro out of your Personal.xlsb workbook and into a regular workbook? You can do it using familiar editing techniques, as illustrated in this tip.

   Opening Personal.xlsb
If you start up Excel 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.

   Personal Workbook Fails to Load
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, however, if the Personal workbook doesn't automatically load when you start Excel?

   Saving Changes in the Personal Workbook
The Personal workbook is a special place used to store information and macros that you can access from all the other workbooks on which you work. If you are confused as to why Excel continually asks whether you want to save this special workbook, here are some ideas on why it may be happening.

   Upgrading Personal.xls to Excel 2007
When upgrading to Excel 2007, you may wonder how you can convert your older Personal.xls file to something that can be used with the newer program. Here's the easiest way to make the transition.

   Upgrading Your Personal Workbook
When you upgrade to Excel 2007, you may wonder if you also have to upgrade to the new format for your Personal workbook. The short answer is that yes, you should upgrade, and there should be no backward compatibility issues in doing so.

This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing