Results 1 to 2 of 2
2006-10-20, 07:22 #1
- Join Date
- Feb 2001
- Thanked 0 Times in 0 Posts
named formula not refreshing/updating (Excel 2002 SP3)
I've just encountered a strange problem. I have a rather large workbook with a recap sheet that totals values form all the various department sheets. Several months ago I gave the formula a name in order to save on my file size. I've had no problems until today. When I began entering data into the various department sheets, I checked on the recap sheet to verify that I had entered the data correctly. The formulas did not update. When I copied and pasted the named formula from another cell, the total then updated. Under options the calculation is set to automatic.
Can anyone suggest what might have happened? No one else ever uses this workbook, and I didn't change any settings. It just seems that I will have to go back to pasting the formula in every cell, because I can't be continually copying and pasting the formula each time I use the workbook. It is my main data repostory for all the departments. I have several years data each department, and many graphs linked to the recap page. I need to be confident that any changes to department pages are reflected in the recap page.
Thanks for any suggestions/ideas on what the problem could be.
2006-10-20, 08:15 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: named formula not refreshing/updating (Excel 2002 SP3)
In general, cell formulas involving named formulas do update automatically, so we'd need to know more about your naned formula.