Wed, 30 Jan 2008 07:43:02 -0800 from adam
:
I am having a problem with an excel model that I created. It has to be
circular by nature, so I have turned calculations off and have to F9 whenever
I want the model's formulas updated.

The problem that I'm having is that I have pages that sum up values from
multiple worksheets and these sum formulas are not updating when I make a
change to the pages that the summary pages reference. I do not have any
macros in the sheet. Does anyone know how to fix this?

Excel 2003 help says that F9 recalculates all worksheets in all open
workbooks. Where are these other worksheets?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/