Find references to blank cells

Find references to blank cells

This test will check all cells in your spreadsheet and check to see whether any of the references are blank cells. Perhaps the formula is accidently pointing to a blank cell (could be a result of a copy paste with incorrect $ signs), or the cell that was there has been deleted.

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