Find unprotected formula cells

Find unprotected formula cells

Cell protection is important in spreadsheets where you are worried about users overwriting your formula. Cell protection is normally put on cells with formulas in. This test will check if all the formula cells will be protected, and warns you of the cells that won’t be.

Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors