Updating links - which cell is trying to update?

[George Taylor]

Hi,

In one of our office spreadsheets, everytime it is opened it asks do you
want to update cells from another spreadsheet. I believe when this
spreadsheet was set up, a work sheet was copied from another spreadsheet. I
thought that all the references to that other spreadsheet had been removed.
Is there anyway to identify (other than manually checking each cell) which
cell has a formula linked to the old spreadsheet.

Thanks in advance,

George

 

[JE McGimpsey]

Download and install Bill Manville's FindLink add-in, which you can find
at:

http://www.bmsltd.ie/MVP/

 

[George Taylor]

Thanks

G

Download and install Bill Manville's FindLink add-in, which you can find
at:

http://www.bmsltd.ie/MVP/