Skip to Content
0
Former Member
May 14, 2008 at 07:39 PM

Using EVDRE:OK cell to populate another cell

13 Views

When there is an error in the "EVDRE:OK" cell, I would like to put a message in the header of the report area so that the end user is aware that there is a problem. I would assume that a formula such as

=IF($A$1="EVDRE:OK","","SOME ERROR MESSAGE") 

would work. Initially, it appears that this does work. However, the report will no longer refresh and Excel locks up. Has anyone done anything similar to this?

~Alison