WebMay 18, 2024 · 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. WebIf a new, blank workbook is not open, do the following: On the File tab, click New. Under Available Templates, click Blank workbook. On the File tab, click Options. In the Formulas category, under Calculation options, click Manual. Click OK. On the File tab, click Open. Select the corrupted workbook, and then click Open.
Personal Workbook Not Loading - Microsoft Community
WebSep 4, 2024 · Every time I open an excel file a pop up says the personal workbook is locked for editing. I can only open the personal workbook as a read only meaning it can't be edited/saved etc. I have also tried to delete the personal workbook but I can't as it says it is open in Excel even though Excel is not open. WebNov 28, 2024 · Depending on the age of the file, it might not open in Excel at all. If you don't have an XLSB file and that's why it's not working with the programs mentioned on this page, then research the file extension you do have so that you can find out which program or website can open or convert your file. Was this page helpful? manga high rise invasion
PERSONAL macro workbook not opening MrExcel Message Board
WebJun 20, 2024 · If the workbook is NOT in the correct place move it and remove as an add-in. Test again. Otherwise You could try this. - find Personal.xlsb in folder as suggested above (we now call this folder A) - move the personal.xlsb to a different folder (folder X) so that Excel cannot use it. - open Excel to test it opens cleanly. WebMay 18, 2024 · When I open the XLSTART folder I see the personal.xlsb file with the correct time stamp. But when I shut down excel and reopen it the personal.xlsb does not load and so when I go to run a macro from it excel does not show it as being available. If I shut down excel, then double click on the personal.xlsb file it opens excel and I now see the ... WebOct 23, 2024 · When the file opens, you will see an option at the top of the worksheet to Enable Functions. Click yes. At this point you can click alt F11 to verify that your macros are there. Assuming they are (this has worked for me every time), simply save the file, and then save back to your original location. korean frequency list