Now, the Personal.xlsb file lives in your Application Data folder. If it is grayed out, you don’t have any hidden files. Tip: PERSONAL.XLSB loads as a “Hidden” file and you can see what other hidden files you may have by going to the View tab on the ribbon and pressing the Unhide button.
The problem with this is that if you open multiple copies of Excel, they all ask the operating system for write permissions in case you want to update the file. The point of it is to give you a place to save commonly used macros that will then be loaded and available to you in whatever workbooks you open. This file loads in the background every time you open a copy of Excel. I recently added some macros into my PERSONAL.XLSB file for Excel and started getting these annoying pop-ups saying that it’s locked for editing.
0 kommentar(er)
