Finding linked cells - Error Prompt

  • Thread starter Thread starter Steve Mc
  • Start date Start date
S

Steve Mc

Is there an easy way to find what cells have formulas that
refer to another worksheet.

I'm trying to Edit-Links-Change Source to the current
worksheet, but am getting the prompt:
Your formula contains an invalid external reference to a
workbook. Verify that the path, workbook and range name or
cell reference are correct, and try again.

I did a search for all the formulas that refer to another
tab ( ! ), such as vol03! and all the cells I found ( I
think I found them all) are referring to tabs that are in
the current workbook.

If I did find them all, could the problem be with 'range
name' ? I don't specifically use range name, but here does
seem to be some there.
Or am I just missing some of the ! references and
possibly I have a formula that is referencing a tab that
is not in this current workbook ?

Hope this is not too confusing.

Thanks,

Steve
 
Back
Top