Linked spreadsheet errors

[Rosemary]

I'm doing a huge (17 page) spreadsheet that is linked to
13 subspreadsheets. I would like to apply an "isblank"
and "iserr" format to the entire spreadsheet. How can I
do this? Info is input onto the subs on a monthly basis,
but the cells that aren't used until later are showing
either "0"s [number format cells] or "#DIV/0!" [percentage-
-calculation] on the main spreadsheet. Can I do this,
and, if so, how? Thank you.

 

[Kray]

Hi Rosemary,

I work with quite a few spread sheets myself that are linked. What I
have found is that each cell that has DIV # is a cell that is not
linked properly.

HTH,
Kathy

 

[Frank Kabel]

Hi Rosemary
AFAIK you have to adapt your formulas to prevent these error:
so change your formula like the following:
=IF(A1=0,"",B1/A1)

Another way would be to use conditional format:
- Highlight the desired cells
- Goto 'Format - conditional format'
- Enter a formula (if A1 is the uppermost left cell of your selected
range):
=ISERROR(A1)
- As format choose a white font

HTH
Frank