On May 20, 5:31*pm, mohavv wrote:
Hi,

I have a large workbook with a lot of links to different files (with
same layout).

I am looking for a way to check if the formula's in a column are all
linked to the same file or folder.
Folder would actually suit better because the filename stays the same.

Example:

C:\forecast2008\details.xls
C:\forecast2009\details.xls

Column C in workbook "summary.xls" sheet1 links to ....
2008\details.xls
Colums D links to ....2009\details

Can't find a way to use the text of the formula for comparisons.

Cheers,

Harold

Harold,
How is Maud? I am sorry, I just could not resist.
Here is a soloution to your quandry.
I a column that is free you are going to write this. This is assuming
that the column you are interested in is A.
=IF(ISERROR(Search("details.xls",A1,1))=True,0,1) Here is how this
reads. If a1 is serached and it can not find details.xls in the cell
it will return a 0, if it can then it will return a 1. then all you
have to do is find the zeros.
Hope this helps,
Jay