It sounds like the sheet is slow because each cell with the formula is
checking the hard disk for the file. Try putting the sheet check into just
one cell giving say 0 for non-existing & 1 for existing, then use an if
condition in the other cells to check that cell?


--
Ian
--
"joeeng" wrote in message
...
How can I check if a worksheet exists before trying the access it? I've
been
using the if text on an iserror for an indirect function, but this causes
the
calculation to be very slow when entered into many cells.