Find Unused calculations in the spreadsheet

Find Unused calculations in the spreadsheet

Good spreadsheet practice suggests that there should be a hierarchy to calculation. You should have an input section, which leads to calculations and ends in reports.

As such, except for the final reports, all inputs should be used somewhere and all calculations should build up to the report and therefore be used.

This test will check whether there are calculation cells that are not being used anywhere else in the spreadsheet as this could be an oversight.

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