Function weirdness - #VALUE, then #NAME, then working fine??
 

Maybe I shouldn't get too deep into this. Maybe it's just a moon
phase or something. I opened up my workbook this morning and all the
values returned by a Function were showing #VALUE errors. I went over
everything carefully, making sure it was picking up the correct values
from the cells it needed, stepping through the code, etc. Everything
came out okay. So I F5 through the code and F9 on the worksheet - and
everything changed to #NAME errors!

Okay - save and close. Reopen and hour later - and everything is
fine!!?!

Am I the victim of some Excel prank (undocumented "feature", that
is!)? Or was it just my turn in the barrel today?

Ed

Function weirdness - #VALUE, then #NAME, then working fine??
 

Are you using a User Defined function? If so, they don't update unless a
value entered into them changes.

"Ed" wrote:

Maybe I shouldn't get too deep into this. Maybe it's just a moon
phase or something. I opened up my workbook this morning and all the
values returned by a Function were showing #VALUE errors. I went over
everything carefully, making sure it was picking up the correct values
from the cells it needed, stepping through the code, etc. Everything
came out okay. So I F5 through the code and F9 on the worksheet - and
everything changed to #NAME errors!

Okay - save and close. Reopen and hour later - and everything is
fine!!?!

Am I the victim of some Excel prank (undocumented "feature", that
is!)? Or was it just my turn in the barrel today?

Ed

Function weirdness - #VALUE, then #NAME, then working fine??
 

Hi, Barb.

On May 22, 1:13 pm, Barb Reinhardt
wrote:
Are you using a User Defined function? If so, they don't update unless a
value entered into them changes.

I've got three spreadsheets with this same function. All of them have
worked fine for weeks. Sometimes the values don't change, so a
Calculate doesn't show me a new result - and I wouldn't expect it to.
It's just the one workbook that went waywire for a little bit. It's
working fine today.

Oh well - I'll just blame it on IT and the patches they push.

Ed

Function weirdness - #VALUE, then #NAME, then working fine??
 

Can you show the function?

"Ed" wrote:

Hi, Barb.

On May 22, 1:13 pm, Barb Reinhardt
wrote:
Are you using a User Defined function? If so, they don't update unless a
value entered into them changes.

I've got three spreadsheets with this same function. All of them have
worked fine for weeks. Sometimes the values don't change, so a
Calculate doesn't show me a new result - and I wouldn't expect it to.
It's just the one workbook that went waywire for a little bit. It's
working fine today.

Oh well - I'll just blame it on IT and the patches they push.

Ed