Modified Linked Cells

  • Thread starter Thread starter MTBer
  • Start date Start date
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
 
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 "+"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Conditional Formatting on a Linked Cell 3
... I would like to link conditional formating to linked workbooks 2
Changing Cell Link on Spin Button Form Control 14
Link cell to another workbook 5
Changing linked worksheet and range of cells 7
modify linked cells without breaking link 1
Formatting cell 2

Back
Top