VBA & Macro Problems

Fix Excel Personal Macro Workbook Macros Not Saving or Appearing

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

Find and save macros in Excel's Personal Macro Workbook.

Fix Excel Personal Macro Workbook Macros Not Saving or Appearing
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants personal macros to be saved and available whenever Excel starts.
Observed behavior
Macros saved to Personal.xlsb may not appear if the workbook is missing or does not load from Excel's startup folder.
Before you start

Open Excel and check whether the Developer tab is available. If it is hidden, select File > Options > Customize Ribbon and enable Developer.

Solution 1Recommended

Check the Personal Macro Workbook and save your changes

Use this method to find macros in a loaded Personal.xlsb file and make sure changes are saved.

1
Check for the hidden workbook

In Excel, select View > Unhide and look for PERSONAL.XLSB. It is normally hidden, so being hidden alone does not prevent its macros from appearing.

2
Find the macro

Select Developer > Macros and check the Macros in list for PERSONAL.XLSB or Personal Macro Workbook. Select it to see the available macros.

3
Save macro changes

Close Excel after creating or editing a personal macro. If prompted to save changes to the Personal Macro Workbook, select Save.

4
Check the storage location

When recording a new macro through Developer > Record Macro, choose Personal Macro Workbook in the Store macro in list before selecting OK.

Keep the workbook hidden: You can leave PERSONAL.XLSB hidden during normal use. If you unhide it to inspect it, select View > Hide afterward.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files to make the transition easier; Excel's Personal Macro Workbook and VBA behavior may differ.

Open and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for everyday workbook tasksWork with spreadsheet formulas and data without relying on Excel's Personal Macro WorkbookUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where does Excel store the Personal Macro Workbook?

On Windows, PERSONAL.XLSB is typically stored in %appdata%\Microsoft\Excel\XLSTART. Enter that path in File Explorer to check for the file.

Does Personal.xlsb need to be visible for its macros to work?

No. PERSONAL.XLSB is normally hidden but can still load and make its macros available. Check Developer > Macros and the Macros in list.

How do I save a new macro to my Personal Macro Workbook?

Select Developer > Record Macro and choose Personal Macro Workbook under Store macro in. Stop recording, then save the Personal Macro Workbook when Excel prompts you on exit.

Will creating a new Personal Macro Workbook recover my old macros?

No. A new workbook creates a new storage file. To recover old macros, locate an existing copy of PERSONAL.XLSB and place it in Excel's XLSTART folder.