gaqchem.blogg.se - Excel file locked for editing error

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).

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.