Please help

  • Thread starter Thread starter howiechc
  • Start date Start date
H

howiechc

my spreadsheet have quite a handful of links in other spreadsheets. i
it can't find the file to link it will be "#REF!". Right? So, m
question is, "is there are way to actually parse a null into tha
particular cell if the cell can't find the file to link?" is there an
way....

any feedback is very much appreciated. thanks a million in advance.


Howie
 
howiechc > said:
my spreadsheet have quite a handful of links in other spreadsheets. if
it can't find the file to link it will be "#REF!". Right? So, my
question is, "is there are way to actually parse a null into that
particular cell if the cell can't find the file to link?" is there any
way....

any feedback is very much appreciated. thanks a million in advance.


Howie.
Click to expand...

use an "If" statement and if the result is #REF then print either " " (a
blank) or some other character you want.
 
You could do something like this:

=IF(ISERROR('C:\My Documents\excel\[book32.xls]Sheet1'!$A$1),"",
'C:\My Documents\excel\[book32.xls]Sheet1'!$A$1)

(one cell)

When I typed it in, excel popped up the "update values" dialog. After I
dismissed that dialog, the formula evaluated to "".

This could be very irritating if you open workbooks and say yes to update links.
 
Back
Top