Nowadays, personal Macro Workbook is known as “Personal.xlsb” but in the earlier version it is known as “Personal.xls”. Personal Macro Workbook stores the macros and the user-defined functions which are written in VBA. You can use this macro codes for any of your workbooks. This saves time of the user because if you have created the Macro for one Excel file then you can use it for that specific file but if you save this macro in Personal Macro Workbook then you can use it on another Excel file also. But sometimes the users encounter issue like Personal Macro Workbook not opening issue. Hence, in this blog you will read the solution to fix Personal Macro Workbook Not Opening Issue. If you need assistance, then you can contact to the customer care of MS Office via www.office.com/setup.
Solution To Fix Personal Macro Workbook Not Opening Issue: office.com/setup
- Personal .xls File Not Opening: To fix this issue, you should check whether the directory is a trusted one or not. For this, first you should open your Excel file and then click on the file and then choose options. Now from the left side of the dialog box, you should click on the Trust Center. After this, you should click on the Trust Center Settings button. Here, the Excel will open the Trust Center dialog box. Now from the left side of the dialog box, you should click on the Trusted Locations. Here, you can view all the directories which are there in the dialog box.
- Personal Macro Workbook Fails to Load: By using Windows, you should locate and rename your Personal.xls file. Then just start your Excel application. Here, you should execute your macro recorder by going to the view option and then select Macro and then choose Record New Macro. After this, just ensure that the macro which you are recording is kept in your Personal.xls workbook. For this, select the “Personal Macro Notebook” and then from the drop-down list of “Store Macro In”. After this, click on OK button just to start your macro recorder. Now, you have to select a different cell in your Excel worksheet. Then you should stop the running macro recorder by clicking on the view option and then select Macro and after this, select Stop Recording. This will create a new personal .xlsb file.
- Unhide Personal Macro Workbook: From your Excel ribbon, you should click on the file and then hit on options. Now in the opened Excel options window, you should click on the Add-Ins tab. Here from the bottom of the dialog box, you should click on the Manage drop-down list and then select the Disabled Items. After this, click on Go option then Excel will show one dialog box which has all the disabled add-ins listed here. In case, your Personal macro workbook is listed disabled, then you should choose it and then click on Enable. At last, you should close all the open dialog boxes.
- Open Your Excel Document Safe Mode: To open Excel in ‘safe mode’, you should press and hold ‘CTRL’ key when opening this program. You can also begin the program from the command line just by pressing on the window+ R key from your keyboard. Now in the opened Run window, you should type ‘excel.exe/safe’ and then click on the OK button.
The above procedure will help you to solve Personal Macro Workbook Not Opening Issue. If the customer wants help or support then they can contact to the expert of MS Office via www.office.com/setup.