Links to other workbooks

  • Thread starter Thread starter tclohesy
  • Start date Start date
T

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
 
Brilliant! Thanks. I had some names defined for the previous workbook
but it didn't affect my data. All sorted.

Cheers

Ton
 
Back
Top