the only way to do it is to make the check in the formula
you could dedicate cells in the main workbook that would just contain the
links to D3 in the other WB's. Use those cells instead of the long reference
in the formula.

"Ken" wrote:

Excel2003 ... I do not usually work between WorkBooks ... I simply do not
like to ... :(

WB1 (Cell D3) ... AVERAGE Formula pulling from <= 10 different WB's (Cell
D3) ... (Works great as long as there is a "value" found)

Issue ... When other 10 WBs (Cell D3) is null ("") (hope I am using the
correct term?) ... My AVERAGE Formula WB1 (Cell D3) is returning the "Div\0"
error.

My fix ... =if(iserror(Average etc etc),"",(Average etc etc)) ... issue here
became length of my Formula because of Drives, Folder Trees & FileNames etc
... Fix ok until Formula to looooooooooong.

Help from any intimate with Excel would be welcome ... Thanks ... Kha


--
Kha