Blog

Details

If you are looking for your personal settings  “PERSONAL.XLSB” file,  you can find can try the locations section listed below.  If the file is not present then you may not have a personal file set up.

In order to set up PERSONAL.XLSB file you will need to first create a macro and save it as personal macro workbook.  The should automatically generate the file with the label PERSONAL.XLSB

For more information on generating this file please see the section below labeled: Generate PERSONAL.XLSB  file

Locations for MS Office 2013 on 64 bit:

C:\Users\YourUserAccountName\AppData\Roaming\Microsoft\Excel\XLSTART

or

C:\Program Files\Microsoft Office\Office15\XLSTART

Microsoft Office Version Chart:

Find the office year version and then use the office version chart to find the folder directory on your machine.

Microsoft Office 2016 = Office16

Microsoft Office 2013 = Office15

Microsoft Office 2010 = Office14

Microsoft Office 2007 = Office12

Microsoft Office 2003 = Office11

HOW to Generate the PERSONAL.XLSB  file
1. Open Microsoft Excel
2. Click the develolper tab (if you dont have this then you need to enable the tab) at the top.
3. In the code section of the ribbon. Select from the code section the button “Record Macro”
4. In the pop up choose the drop down option to Store macro in: Personal Macro Workbook.
5. File has been generated. Done.

References:

http://wheatblog.com/2011/08/where-is-the-excel-personal-macro-workbook-located/

Recording Macro Ref: https://support.office.com/en-us/article/Create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790

Run a Macro on startup: https://analysistabs.com/excel-vba/run-macro-automatically-opening-workbook/