Excel Sheet Locked For Editing By Someone Else. Choose the cells which you want to lock from editing. Click on the “review” tab on the main excel ribbon.

Excel asking for a password on an unprotected file
Excel asking for a password on an unprotected file from

If you want users to be able to edit a particular cell or range, uncheck the locked box so they are unlocked. Once we protect the worksheet (in the next step) those locked cells will not be able to be altered by users. When you protect a worksheet, excel locks all of the cells from editing.

To See The Hidden Lock File (~$.Xls [Mx]):

The user in question is our previous network administrator. We using a shared excel sheet stored in onedrive and shared with multiple users. In the last few weeks i am getting users calling me telling me that an excel document that they are trying to access is locked for editing by a user who is no longer here and has not been here for about 2 years.

Hi I Have An Excel Spreadsheet That I Share With Another Local Office.

The last time this occurred i. Apply the following steps to protect specific cells from editing: I have an excel shared workbook stored on a legacy sharepoint 2010 document library, which needs to be opened for editing by multiple users via a vba tool.

Delete The Password That Appears, So That The Field Is Blank.

When i try and open it, it says that it is locked for editing by me when i know this is not the case. Note down the file name and the path to the excel file. I am not sure whether the library enforces checkout before editing, but i am not the site owner and do not even have permissions to see this setting.

I Have Excel 2003 Files On A Windows Share (Win2K3 Server).

Enable show hidden files, folders, and drives, and disable hide protected operating system files. How to remove a password to unencrypt an excel spreadsheet. You can also protect individual worksheets from editing.

· I Am Having This Same Problem, Although The.

When you protect a worksheet, excel locks all of the cells from editing. We are using excel 2010 and sometimes users are working from a network share. I have an automated unmanned workbook 'alpha' periodically running a macro to open up workbook 'beta' to process data and then save workbook 'beta'.


Leave a Reply

Avatar placeholder

Your email address will not be published.