Forum Discussion

tomrdillon1944's avatar
tomrdillon1944
Copper Contributor
May 18, 2020

PERSONAL.XLSB won't load after launching Excel

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 ...
excel
tomrdillon1944's avatar
tomrdillon1944
Copper Contributor
May 20, 2020

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  

  • laromaf's avatar
    laromaf
    Copper Contributor
    Sep 13, 2025

    thanks! I actually put the standard path to the standard folder to Personal.xlsb and worked! so, didn't need to create a new folder. although doesn't know if it should have said the folder in the first place

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 21, 2020
    Can you now still record macros into your personal macro workbook?
    • tomrdillon1944's avatar
      tomrdillon1944
      Copper Contributor
      May 21, 2020
      yes

Resources