Links to other workbooks

[tclohesy]

I have used a previous workbook and added different data, but wanting
the same analysis, graphs, etc. So I did Save As, and now have several
different workbooks with different data, but on the same basic layout.
However, when I open the newest, Excel asks me if I want to update
links to an external workbook. This is a bit concerning, as it could
mean that some of the data is being sourced from the wrong data. I
used names in my data ranges in some cases, but some of the workbooks
that are showing this didn't use any names. Does anyone know how I can
find the bits that are linking to some other file?

Thanks a lot,

Tony

 

[J.E. McGimpsey]

Check out MVP Bill Manville's FindLink add-in:

http://www.bmsltd.co.uk/MVP/Default.htm

 

[tclohesy]

Brilliant! Thanks. I had some names defined for the previous workbook
but it didn't affect my data. All sorted.

Cheers

Ton