Modified Linked Cells

M

MTBer

I have a large spreadsheet that is linked to several source files
unfortuntely over the past six months usrs have modded this file b
adding values to links to get the reporting value as required

ie =(LINK) has now become =(LINK)+100

is there a fairly easy way of identifying those cells that have bee
changed in this manner.

I have used the GET.CELL function combined with conditional formatting
but as I expected this just notified me that all my cells wer
formulae.

I looked at .HasFormula in VBA.

I'm not looking frward to reviewing every cell individuall
 
B

bj

If the spread sheet does not have many non link cells with
calculations and all of the changes are additions

use [edit][find] "+" and [find next] to go from cell to
cell containing an "+"
 
Top