Take care not to forget this password if you lose it, you won't be able … Click OK.Re-enter your password.Click OK.Close your document. Advertisement.Click Protect Workbook.Click "Encrypt with Password".Type in a password. This is in the top left corner of the screen. How to Password Protect an Excel Spreadsheet (with Pictures) On the next screen, expand the list of Open Files > right-click on the Locked Excel File and … Back on the Add or Remove Snap-ins screen, click on OK to Add the Snap-in to manage …Ĩ. On the next screen, select Another computer and click on the Browse button to locate the …ħ. On the Add or Remove Snap-ins screen, select Shared Folders and click on the Add button.Ħ. On the next screen, click on File > Add/Remove Snap-in.ĥ. In Run Command window, type mmc and click on OK to bring up Microsoft Management …Ĥ. Right-click on the Start button and click on RUN.ģ. Note down the File Name and the Path to the Excel File.Ģ. Note down the File Name and the Path to the Excel File.Right-click on the Start button and click on RUN.In Run Command window, type mmc and click on OK to bring up Microsoft Management … On the next screen, click on File > Add/Remove Snap-in.On the Add or Remove Snap-ins screen, select Shared Folders and click on the Add button.On the next screen, select Another computer and click on the Browse button to locate the … Back on the Add or Remove Snap-ins screen, click on OK to Add the Snap-in to manage … On the next screen, expand the list of Open Files > right-click on the Locked Excel File and … See full list on ġ. User wants to have that Excel spreadsheet be password-protected, shared to his users with read-only permission & him be the only one who can edit it.Excel File is Locked For Editing By Another User I'm thinking that Office Apps are having a hard time syncing the changes made by the user because of the password that was set to the file. Tried downloading a copy of the Excel spreadsheet, removed the password & have it uploaded back to OneDrive.
We've unsynced & resynced his OneDrive account & error still pops out. " resulting on him not able to edit the file. When he tries to open the password-protected Excel spreadsheet from the OneDrive (online) or OneDrive Desktop App, error pops out: "Error: Read-only: This workbook is locked for editing by another user. Inside that shared folder, there's an Excel spreadsheet which is password protect, also shared with other users (read-only permission) & the owner (user) of the Excel spreadsheet only has the Full Access to the file. User have a folder from OneDrive (online) shared with other users.
0 kommentar(er)
