The new user who wants to edit the file now will be able to exit Excel, then re-open the file to edit it. Thats it You have disconnected the user who had the file open and unlocked it. If you are logged in at a different computer, select Another computer, then type or Browse to the server where the Excel file resides.įind the file in the list, then right-click the file and choose Close Open File. If you are logged in on the server where the locked Excel file resides, choose Local computer. In the list of Available snap-ins, select Shared Folders, then select Add to add it to the Selected snap-ins list.Ī box will appear that asks you to Select the computer you want the snap-in to manage. Type mmc, then press Enter to bring up the Microsoft Management Console. Hold the Windows Key and press R to bring up the Run dialog box. To boot the user from the file and allow another user to access it, follow these steps: Note the path to the file, and the file name. If you cannot perform these steps, talk to your IT folks for them to perform these steps for you. Note: These steps are for System Administrators or personnel with Administrator access to the server where the Excel file resides. If the user is away at lunch or gone for the day, and the file needs to be edited now, it makes it quite the conundrum.įortunately, there is a way to kick the user out of the file remotely. Open Read-Only or click Notify to receive notification when the document is no longer in use. The message that appears will say File in Use filename is locked for editing by username. Ryan says at 11:40 am Thanks Quick and to the point.
The best way to unlock it should be removing open password from excel file and you could open it at any time without password requirement.īut dont worry, because you can remove the editing restrictions just with software, iSunshare Workbook Unprotect Genius.Īnd click Open button on Workbook Unprotect Genius, then select locked excel file to import into iSunshare software. Unlock Excel File Locked For Editing On Password Protected Excel Unlock Excel File Locked For Editing On Password Protected Excel.
0 kommentar(er)
