Accidental | search
Click here to view Accidental news from 60+ newspapers.
Bookmark or Share- Restrict changes to files in Excel - Microsoft SupportIf you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers from making changes to your document or spreadsheet, you can make the file read-only or you can password protect it.
- Remove or allow a circular reference in Excel - Microsoft SupportRemove or allow a circular reference in Excel. You've entered a formula, but it’s not working. Instead, you’ve got this message about a “circular reference.”. Millions of people have the same problem and it happens because your formula is trying to calculate itself.
- Lock or unlock specific areas of a protected worksheetFollow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.
- Protect a worksheet - Microsoft SupportTo prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password. Say you own the team status report worksheet, where you want team members to add data in specific cells only and not be able to modify anything else.
- 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.
More
