What is the Excel Personal Workbook Location?

The Excel Personal Macro Workbook is the workbook that contains all your created macros in one place.

This workbook usually opens whenever you start Excel, but since it is hidden, you cannot see it.

The exact location of the Personal Macro Workbook, though, can be a little hard to find, since you will not find it in your Documents folder, along with your other Excel documents.

In this tutorial, we will show you how to find the location of your Excel Personal Macro Workbook.

We will also show you how you can view the personal workbook, in case you want to make edits to any of your macros.

Why is there a Personal Macro Workbook in Excel?

When you write or record a macro in Excel, you can only access it from the particular workbook where it was created.

But recreating macros every time you open a new workbook can just be futile. 

So Excel lets you store your frequently required macros in one place (the Personal Macro Workbook), which is always open in the background whenever you start the Excel application.

In this way, your macros are accessible all the time and in any workbook!

How to Create an Excel Personal Macro Workbook?

Every time you write or record a macro, Excel gives you the option to save it in the Excel personal macro workbook.

If you don’t already have an Excel Personal Macro Workbook, you can create one very easily as follows:

  1. From the Developer menu, click on ‘Record Macro’ under the ‘Code’ group.
Click the Record Macro button
  1. This will open the Record Macro window.
  2. Type in a name for the Macro (if you want) and from the dropdown menu under ‘Store macro in:” select ‘Personal Macro Workbook’.
Store the macro in Personal macro Workbook
  1. Click OK.
  2. This will now start recording your macro. If you have a macro that you want to record then go ahead and record it, otherwise, simply move to the next step.
  3. Click ‘Stop recording’ from the Developer tab.
Click on Stop Recording
  1. You are now done recording your macro.
  2. Close the Excel window, and you will be asked if you want to save the macro you just recorded to the Personal Macro Workbook.
  3. Click Save.

Your Personal Macro Workbook should now be created.

Location of the Excel Personal Workbook

The Personal Macro Workbook is always stored in a special file named ‘personal.xlsb’ in newer Excel versions (2007 onwards). In earlier versions, it is saved as ‘personal.xls’.

Personal Macro workbook is always stored in the XLSTART folder.

Excel always looks in this folder whenever it launches. So any file stored here gets loaded as soon as Excel starts.

The problem is, the location of this folder may be a little tricky for us to find.

So here’s a simple hack that you can use to quickly get the location of the XLStart folder.

  1. From the Developer tab, select Visual Basic.
Click on Visual Basic option in the Developer tab
  1. This will open the Visual basic Developer window.
  2. You will see the Project window on the left, containing a list of all your VBA projects and modules under them.
Project Explorer will show the Personal.XLSB
  1. Select ‘VBAProject (PERSONAL.XLSB)’.
Click on the Personal.XLSB option in the project explorer
  1. Under the Immediate window (at the bottom of your Developer window), type “?thisworkbook.Path”.
Enter ?thisworkbook.Path in immediate window
  1. Press the Return key
  2. You should now see the path of the folder that contains the ‘Personal.xlsb’ file in your computer.
The immediate window gives you the location of the Personal Macro Workbook folder
  1. Copy this path and paste it into the File location bar of your File Explorer and press the return key.
Open the folder

You should now be able to see your personal macro workbook as ‘personal.xlsb’ in the XLSTART folder.

PERSONAL file in the XLSTART folder

How to Unhide a Personal Macro Workbook

The Personal macro workbook is always available in any open Excel workbook. The reason we don’t see it though is that it remains hidden in the background.

You might want to see this workbook, maybe to make edits to macros stored in it, or for any other purpose.

To view the personal macro workbook, you need to simply unhide it.

Here’s how you can do this:

  1. From the View menu, select the ‘Unhide’ button (under the ‘Window’ group).
Click on Unhide in View window
  1. This will open the Unhide dialog box, from where you can select the hidden workbook that you want to unhide.
  2. Select ‘Personal’ from the list of workbooks displayed in the box and click OK.
Click on the personal option in the Unhide workbook dialog box
  1. This will unhide your personal macro workbook and bring it to the foreground.
PERSONAL macro workbook comes to the foreground

This workbook is basically blank, consisting only of macros that you had saved. However, if there’s certain information or data that you want to make available in all workbooks then you can go ahead and add it to the personal macro workbook.

To hide the workbook once again, simply click on View->Hide.

Click on Hide in the VIEW tab

In this tutorial, we explained what the Excel Personal Macro workbook is, how it works as well as how to locate it in your computer’s files and folders. 

We also showed you how to view the workbook, make changes to it, and then how to hide it again, so that it keeps running in the background without interfering.

We hope this was helpful.

Other Excel tutorials you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

2 thoughts on “What is the Excel Personal Workbook Location?”

  1. Hi Steve!
    I recently got a new computer and installed a number of programs (Quickbooks Desktop 2018, Sage, Quicken, etc.). For some reason I can no longer export files in Quickbooks to excel format. The only option is comma-delimited format. I have searched high and low for a solution and all I get it is that Microsoft Office is corrupt or my Quickbooks is not updated. Well, Quickbooks IS updated and I have no problem exporting files from all other programs to excel format. Do you know what the problem is?

    Sincerely,
    Susan

    Reply

Leave a Comment