Welcome to #macromondays again. Today let’s look at removing your Personal Macro Workbook.
This workbook will be named personal.xlsb in Excel versions >2007 and if you have a version of Excel prior to 2007 then the workbook will be called personal.xls.
If you don’t need or use the workbook then you can just delete it. There are a few steps to it so just follow along.
Here are some other blog posts you may find useful
Remove Your Personal Macro Workbook
The file is in a specific location. It is is the XLSTART folder. This can be in a few locations, but first you may need to see hidden files and folders on your machine, if this is the case then follow the steps below (Windows 8, Windows 10).
- Windows Explorer
- Show/Hide Group
- Tick Hidden Items – if not already selected
Once you have enabled Hidden Items then you can proceed to finding the file and deleting it. Navigate to the following folder in Windows 8
If you are using Windows XP you need to navigate to the following location
C:\Documents and Settings\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB
Once you have located the file then just delete it. It will not load again once you restart Excel.
Don’t forget to sign up to the Excel at Excel Newletter for 3 free Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below.