Remove all formulas from entire spreadsheet

Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

The risk with deleting unwanted information from a spreadsheet is that it may be used somewhere and suddenly your spreadsheet breaks with incorrect calculations and #REF errors. So before you delete the sensitive info, remove all the formulas in the spreadsheets

Lesson tags: vlookup
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Control access to information in Excel Spreadsheets