Find external links in Excel spreadsheets

Find external links in Excel spreadsheets

A common spreadsheet risk is links or reliance on external spreadsheets. This could be:

  • purposeful i.e. the formula are linked to another reference file, or
  • accidental e.g. when you saved as version 2 some formula are still looking at version 1.

Either way it is important to check what the links look at as there are issues with linking spreadsheets that you need to be aware of.

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