Fix Excel Personal Macro Workbook Macros Not Saving or Appearing
Question details
Find and save macros in Excel's Personal Macro Workbook.

- 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.
Open Excel and check whether the Developer tab is available. If it is hidden, select File > Options > Customize Ribbon and enable Developer.
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.
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.
Select Developer > Macros and check the Macros in list for PERSONAL.XLSB or Personal Macro Workbook. Select it to see the available macros.
Close Excel after creating or editing a personal macro. If prompted to save changes to the Personal Macro Workbook, select Save.
When recording a new macro through Developer > Record Macro, choose Personal Macro Workbook in the Store macro in list before selecting OK.
Check whether Personal.xlsb is in Excel's startup folder
Use this method if the Personal Macro Workbook does not appear to load when Excel starts.
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.

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.




