Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart allignment issue in 2007 but in 2003 its working fine | Charts and Charting in Excel | |||
Visual Basic Function works fine in Excell 2003 but not in Excel 2 | Excel Discussion (Misc queries) | |||
Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
Macro fine Run fine from Select but not from KB Shortcut? | Excel Discussion (Misc queries) | |||
Weirdness | Excel Programming |