A file created by Excel 2016 is not exactly the same as a file created by Excel 2010, even though they both have the same file format. In addition, if you created your spreadsheet with a different Excel version, we recommend creating another spreadsheet with the version of Excel available on your computer and migrate your data to the new spreadsheet. By migrating the data, the corruption won’t be transferred to the new file, and this might help in preventing some errors when the file is shared. And fixing the corruption might take longer than migrating the data of the workbook to a new one. Sometimes an Excel spreadsheet might include some corruption and raises errors while it’s shared. Creating a Clone of Existing Excel Workbookīy creating a fresh copy of your Excel file, you can reduce the chance of getting errors in a shared Excel file. If no response is received, then the inactive user is removed. A custom macro can ask users every few hours if they are active. You can also write a macro that automatically removes inactive users from a shared Excel file.
The nail may be stuck in your tire for a long time without you even noticing, and then all of a sudden your tire goes flat, or the file becomes unreadable or displays strange symptoms.” You can compare file corruption to getting a nail in your tire. Corruption can be caused by many different scenarios, for example, a network glitch while saving, a power surge, copying and pasting in corruption from another file, the list goes on. Corruption can exist in the “shell” of the workbook, or in certain areas, such as a PivotTable, styles, defined names, objects, or the calculation chain/formulas. A file with corruption might still be opening and functioning, but at some point the corruption might cause some problems.īefore trying to get deep into solutions, we share a response from Microsoft, “Please keep in mind that it’s often quite difficult, if not impossible, to determine where corruption comes from. These errors might be rising because of a corruption in your Excel file.
Therefore, each user can only save their workbook individually to their local computer, which will result in having different copies of the same Excel file on different computers.This scattered unsaved data might be a considerable risk to your business, and transferring it from the workbooks of each user to the original one might be risky due to human error. They’ll no longer be able to save their data to the shared Excel file. These errors might unshare the shared workbook with users. In this article, we address some of the solutions to this problem. This might indicate a user whose computer is not up-to-date with patches.You might get unexpected errors on a shared workbook, such as the “unreadable content”, or “ is locking the document” errors. The name displayed in is from the “Personalize your copy of Microsoft Office” (File/Options/General).ThereĪre Office patches which claim to resolve this issue at the workstation level, but deleting the temporary file is the most efficient workaround. Evidently there are circumstances under which the temporary file is left behind, resulting in an erroneous “File locked for editing by ”. The temporary file should disappear when the document gets closed.It is a hidden file as well as a “protected operating system" file, so it will not normally be displayed in the folder contents unless the View tab in Folder Options has been modified. The name of the temporary file is the same as the document with a tilde ( ~ ) inįront of it. Excel (and probably any MS Office application) creates a temporary file in the same folder as the document when someone opens it on the network.It's just a temporary file that needs to be deleted.
In my case, it wasn't nearly as complicated as some related threads might indicate.
#SHARED EXCEL FILE LOCKED FOR EDITING BY ME WINDOWS#
I've been having this issue on one of my Windows networks and finally took the time to figure it out.
0 kommentar(er)
