Locked | search
Click here to view Locked news from 60+ newspapers.
Bookmark or Share- Excel file is locked for editing - Microsoft SupportThe first thing to try is to turn off the Shared Workbook feature. Also, if you are opening a snapshot from SharePoint, open the workbook itself instead. If those two solutions don't work, try one or more of the following. If possible, remove password encryption or restricted access from the file.
- Protect a worksheet - Microsoft SupportRight-click anywhere in the sheet and select Format Cells (or use Ctrl+1, or Command+1 on the Mac), and then go to the Protection tab and clear Locked.
- Handling data source errors (Power Query) - Microsoft SupportAlso, if the file is open it may be locked, and can’t be accessed until it is closed. This can happen when the other person is using a non-subscription version of Excel. Ask them to close the file or check it in. For more information, see Unlock a file that has been locked for editing.
- Split panes to lock rows or columns in separate worksheet ...This brings a tight focus onto Q4 and the YTD totals in columns G and H. To undo a split, simply click View > Window > Split again. Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.
- Restrict changes to files in Excel - Microsoft SupportRestrict changes in Excel. On the Review tab, in the Protect group, review the following protection options: Protect Sheet Protect the worksheet and contents of locked cells. Protect Workbook Protect the workbook for structure and Windows.
More
