![excel file locked for editing by me mac excel file locked for editing by me mac](https://www.howtogeek.com/wp-content/uploads/2018/06/office_excel_lede.png)
I think that for most users, this will be sufficient.
EXCEL FILE LOCKED FOR EDITING BY ME MAC 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 LOCKED FOR EDITING BY ME MAC 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. I’ve looked around and can’t seem to find an option to turn off that notification. Simply go into the folder above and delete the file. That works to remove the locked for editing pop up, but unfortunately, now I am getting a pop up every time I open Excel notifying me that PERSONAL is a Read-Only copy. 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.
![excel file locked for editing by me mac excel file locked for editing by me mac](https://www.easeus.com/images/en/data-recovery/drw-pro/windows-management-console-5.png)
If you can’t find it, try replacing “Roaming” with “Local” or do a search. Where the name of the user identified is the user who is attempting to open the file. Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use.
![excel file locked for editing by me mac excel file locked for editing by me mac](https://images.imyfone.com/passper/public/media-sites.jpg)
You may also find it somewhere like this:Ĭ:\Users\YourWindowsUsername\Application Data\Roaming\Microsoft\Excel\XLSTART\Ĭ:\Users\Documents & Settings\Application Data\Microsoft\Excel\XLSTART\ When attempting to edit a document or spreadsheet, the user gets a message: File in Use. 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.