Reference to a nonexistant worksheet

  • Thread starter Thread starter Chris R. Lee
  • Start date Start date
C

Chris R. Lee

Hi,

This may sound like a daft question, but I'd like to use functions that
refer to a worksheet that hasn't yet been created or copied into the
workbook.

Obviously if you just type in your formula you get #REF! (I assume this
error message is the same in English & French).

Is there a workaround?

My question is a general one, but the specific context is that an external
application uses a DDE link (or similar) to write to the worksheet in
question. When the application is set up to erase everything in the target
worksheet before sending data, Excel 2000 decides (momentarily at least)
that the worksheet doesn't exist any more. There is no problem when I use a
slower computer running Excel 97.

Regards
 
Doesn't the error disappear once the WB *is* created and the links are
updated?

Or, are you just questioning the ability to "hide" the error until the
linked data is created?

A generic answer to eliminating the display of errors is by utilizing an IF
statement to test their existance, and then if present, replace with a
"null" ("").
For example:
=IF(ISERROR(your formula),"",your formula)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi,

This may sound like a daft question, but I'd like to use functions that
refer to a worksheet that hasn't yet been created or copied into the
workbook.

Obviously if you just type in your formula you get #REF! (I assume this
error message is the same in English & French).

Is there a workaround?

My question is a general one, but the specific context is that an external
application uses a DDE link (or similar) to write to the worksheet in
question. When the application is set up to erase everything in the target
worksheet before sending data, Excel 2000 decides (momentarily at least)
that the worksheet doesn't exist any more. There is no problem when I use a
slower computer running Excel 97.

Regards
 
Back
Top