Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Values Not Refreshing
Hi there,
I have a complex function that sums or averages a series a values, based on month. Occasionally, when i open the workbook and specifically, the sheet, the function shows as '0' or 'NA' even though there are values that meet the date criteria. If i go into the function and click in it, then press enter, the value appears. Now, i could do this for all 200 functions, on three sheets, but that won't work. What can i do to make this stop. I have checked Tools Options Calculations and it is set to automatic. Ideas? -- Carlee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing external data breaks sorting of function columns | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Refreshing a User Defined Function | Excel Discussion (Misc queries) | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
Web Services function call and data refreshing | Excel Worksheet Functions |