The files are supposed to be deleted when Excel and/or the file is closed. If you’re editing your macro file every day, perhaps you need to consider making your macros more generic so they take parameters from, say, an InputBox. Make sure that all the users in your organization delete the files and open the file to see if you can edit it. I think that for most users, this will be sufficient.
#Excel file is locked for editing osx update
Please note that if you want to edit the file again, to add another macro for example, you’ll have to un-check the read-only box, update the file and then recheck it. For example, I had both PERSONAL.XLSB and PERSONAL-2.XLSB which would load at startup for me. Then, on the General tab under Attributes, check the “Read-only” box.ġ You can have more than one PERSONAL.XLSB file.Highlight them and view their properties (Right-click -> Properties).Go into the folder above and find the file(s 1).
#Excel file is locked for editing osx windows
This resolves the conflict that having multiple windows open would normally cause. This will force all Excel windows to open it only for reading, not writing. If, like me, you find this file helpful, then you can make it read-only. Once it’s gone, Excel will no longer try to load it and you won’t get this message. Simply go into the folder above and delete the file. There are two main ways to fix this issue (that I’m aware of) and which to use depends on whether you actually use the file or not. If you can’t find it, try replacing “Roaming” with “Local” or do a search. You may also find it somewhere like this:Ĭ:\Users\YourWindowsUsername\Application Data\Roaming\Microsoft\Excel\XLSTART\Ĭ:\Users\Documents & Settings\Application Data\Microsoft\Excel\XLSTART\ Typically, you can find it here:Ĭ:\Users\YourWindowsUsername\AppData\Roaming\Microsoft\Excel\XLSTART\ 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)
