Forum Discussion
Can't edit macros in Personal.xlsb
If I may add these suggested solutions...
It sounds like you’re having trouble saving changes to your Personal.xlsb file due to an error with a temporary file.
Here are a few things you can try to fix the issue:
- Make sure you have the necessary permissions to save files to the XLSTART folder. You can check this by right-clicking on the folder, selecting “Properties”, and then going to the “Security” tab.
- Try deleting any temporary files in the XLSTART folder that may be causing the issue. You can do this by going to the XLSTART folder and deleting any files that begin with “~$”.
- If the above steps don’t work, you can try resetting Excel’s settings by renaming the Excel15.xlb file. This file is located in the %APPDATA%\Microsoft\Excel folder. Close Excel, rename the file (e.g., to Excel15.old), and then restart Excel. This will reset Excel’s settings and may fix the issue.
Please note that editing the Windows registry can be risky and can cause problems with your computer if not done correctly. Make sure to follow the instructions carefully and only make changes to the specific registry keys mentioned in the article.
I hope one of these solutions works for you!
If I may add these suggested solutions...
It sounds like you’re having trouble saving changes to your Personal.xlsb file due to an error with a temporary file.
Here are a few things you can try to fix the issue:
- Make sure you have the necessary permissions to save files to the XLSTART folder. You can check this by right-clicking on the folder, selecting “Properties”, and then going to the “Security” tab.
- Try deleting any temporary files in the XLSTART folder that may be causing the issue. You can do this by going to the XLSTART folder and deleting any files that begin with “~$”.
- If the above steps don’t work, you can try resetting Excel’s settings by renaming the Excel15.xlb file. This file is located in the %APPDATA%\Microsoft\Excel folder. Close Excel, rename the file (e.g., to Excel15.old), and then restart Excel. This will reset Excel’s settings and may fix the issue.
Please note that editing the Windows registry can be risky and can cause problems with your computer if not done correctly. Make sure to follow the instructions carefully and only make changes to the specific registry keys mentioned in the article.
I hope one of these solutions works for you!
NikolinoDE Thanks. It does look like it was a permissions problem. I tweaked a couple permission settings and now it looks like it is working. Thanks for pointing me towards a solution!.
Joe
- I'm glad that the problem could be fixed.
I wish you continued success with Excel!
Hello,
Thank you for these tips. I will try with caution.
I have already found a partial solution, but it is not satisfactory: if I create a macro for the open document, I can
modify it. But it cannot be used for new documents. So I will try the solutions you suggest and let you know;
Thanks,
JP
