Deleting that temporary file fixed it for me. I Have not tried the method as posted by Bob Longmire but I am skeptical it will have a resolve rate for the issue. You should see a temporary file for the file in question, delete the temporary file. If the System Configuration Utility itself appears, click the red X at the top right corner of the dialog box. Step 3: Type the password again to confirm. As you can see, there are options to permit various types of editing on a sheet-wide basis. Before you start Before you lock up a workbook or sheet, make sure the viewing settings are suitable.
To put it in a short way: There is no complete solution for this problem. In my case, this file had become corrupt and was stuck displaying an earlier modify date from a few days ago. Enable worksheet protection Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. Some users try to access these shared files. Is the file server Windows, too? However another user did have it open. All the rest of the documents I leave alone.
Only the different is I's using my own laptop which I don't share with anyone or network. This worked for me too. These other processes are notified by Windows when there are changes to the file and they then attempt to get a handle to the file themselves. Note: These steps are for System Administrators or personnel with Administrator access to the server where the Excel file resides. The temp file was 9 months old.
You are using a database application whose documentation recommends that oplocks be turned off. Sheet Protecting at the sheet level gives you a lot more options than locking the entire worksheet. Thanks We are having the same issue. The are reside on shared folder on the server. The file is a commonly used file on our network.
When you open the file in Excel 2007, a File In Use dialog box appears. Then select the File Block Settings. If you click on the bottom of a sheet inside your workbook, you will notice that the options to change the workbook structure, such as Insert, Delete, Rename, Move, Copy, Hide, and Unhide sheets are all unavailable. That must be the problem. I just realized this thread was answered and you are having this same problem - probably should have started a new thread and referenced this one as a similar issue but not the same as you have already tried it right? Click on the Protect Workbook button and select the Encrypt with Password from the expanded options. With no password the protected workbook can be unlocked and edited with a click of the mouse. It simply prevents users from modifying locked cells within the worksheet.
A client can then read from or write to a file without regularly reminding the server that it needs access to the file in question. I attempted all the above fixes that were suggested but the wrong username was still being displayed. There are various places to set or check the lock status of cells. In cases where the wrong user name is displayed in the file lock dialog Sometimes where it says 'another user' it has the name of someone that didn't open the file or it has no name at all. Step 2: Protect the worksheet Next, select the actions that users should be allowed to take on the sheet, such as insert or delete columns or rows, edit objects, sort, or use AutoFilter, to name a few.
Has anyone experienced this issue and care to share the resolution? I don't see any hidden files even after enabling the show hidden files and Hide protected operating system files options. This has been in Excel for a long time and the source of much confusion. This article attempts to break the file locking problem down categorically so that it's easy to diagnose and fix. In my case the problem is that the owner file ~filename. You should see a temporary file for the file in question, delete the temporary file.
But there will be one yellow warning under the Excel toolbar. I personally like to sort by username. We have been in contact with Microsoft team for months, but so far no resolution. It would say their name for anyone accessing the file. I would recommend setting a default on required meta data if you can and educate users on setting properties in Office Documents. This can happen if something interrupts the process and breaks Excels connection with the file.
To prevent this condition, the storage system delays sending an oplock break according to the delay time value in milliseconds specified by the cifs. Try accessing shared files with these programs shut off. Instead of closing an open file in the Open Files category, I went to Sessions category and located the user who had the locked session with that file. To edit cell A2, you have to unprotect the sheet. After completion, reset the checks for the hidden attributes above. Why is Excel reporting the wrong user having the file open? Choose Review Protect Sheet or right-click on the sheet tab and choose Protect Sheet. Choose this option and when the lock is released, the user will be able to then choose to open the file in edit mode.
Simply, because your file is locked by another process. This can be the antivirus software or this can be a synchronization process of the operating system e. This applies to any file and any program in Windows. Then click on the box names last saved by. Filed Under: , Tagged With: Reader Interactions.