Control access to information in Excel Spreadsheets

Remove all formulas from entire spreadsheet

This is a preview lesson
Register or sign in to take this lesson.
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