PERSONAL.XLSB won't load after launching Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1400569%22%20slang%3D%22en-US%22%3EPERSONAL.XLSB%20won't%20load%20after%20launching%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1400569%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20new%20macro%20and%20saved%20it%20in%20the%20personal%20macro%20workbook.%20The%20personal.xlsb%20file%20was%20saved%20out%20to%20XLSTART%20folder.%20But%20when%20I%20launch%20Excel%20it%20does%20not%20load%20the%20personal%20macro%20file%20so%20I%20can't%20see%20it%20or%20run%20thing%20from%20it.%20If%20I%20open%20the%20personal.xlsb%20file%20first%20by%20just%20double%20clicking%20it%20will%20open%20up%20Excel%20and%20I%20can%20see%20the%20personal%20macros.%20Can't%20figure%20out%20why%20it%20does%20not%20load%20automatically%20when%20Excel%20is%20launched.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1400569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1401719%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%20won't%20load%20after%20launching%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1401719%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20in%20the%20list%20of%20Disables%20Items%20perhaps%3F%20File%2C%20Options%2C%20add-ins%20tab%2C%20use%20drop-down%20near%20the%20bottom%20and%20select%20disabled%20items.%20Then%20click%20Go...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406592%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%20won't%20load%20after%20launching%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406592%22%20slang%3D%22en-US%22%3E%3CP%3EI%20solved%20the%20problem%20with%20a%20workaround.%20You%20can%20define%20a%20folder%20that%20contains%20files%20that%20will%20automatically%20open%20when%20you%20launch%20Excel.%20So%20I%20created%20a%20folder%20called%20EXCEL%20START%20and%20I%20put%20my%20personal.xlsb%20file%20in%20the%20folder%20and%20now%20it%20all%20works%20perfectly.%20I%20could%20never%20find%20out%20why%20it%20would%20not%20load%20from%20the%20normal%20location%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579699%22%20target%3D%22_blank%22%3E%40tomrdillon1944%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20setup%20a%20folder%20loading%20go%20to%20Options%2FAdvanced%2FGeneral%20and%20fill%20in%20the%20file%20path%20for%20the%20folder%20you%20want%20to%20use%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406638%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%20won't%20load%20after%20launching%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406638%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579699%22%20target%3D%22_blank%22%3E%40tomrdillon1944%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPossibly%20a%20bad%20registry%20key.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408163%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%20won't%20load%20after%20launching%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408163%22%20slang%3D%22en-US%22%3ECan%20you%20now%20still%20record%20macros%20into%20your%20personal%20macro%20workbook%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408436%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%20won't%20load%20after%20launching%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408436%22%20slang%3D%22en-US%22%3Eyes%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I created a new macro and saved it in the personal macro workbook. The personal.xlsb file was saved out to XLSTART folder. But when I launch Excel it does not load the personal macro file so I can't see it or run thing from it. If I open the personal.xlsb file first by just double clicking it will open up Excel and I can see the personal macros. Can't figure out why it does not load automatically when Excel is launched.

5 Replies
Highlighted

Is it in the list of Disables Items perhaps? File, Options, add-ins tab, use drop-down near the bottom and select disabled items. Then click Go...

Highlighted

I solved the problem with a workaround. You can define a folder that contains files that will automatically open when you launch Excel. So I created a folder called EXCEL START and I put my personal.xlsb file in the folder and now it all works perfectly. I could never find out why it would not load from the normal location @tomrdillon1944 

 

So setup a folder loading go to Options/Advanced/General and fill in the file path for the folder you want to use  

Highlighted

@tomrdillon1944 

Possibly a bad registry key.

Highlighted
Can you now still record macros into your personal macro workbook?
Highlighted