I have a rather large file with many spreadsheets of financial data.
The summary page rolls up all the other worksheets into one financial
statement.

I am updating the worksheets, and I noticed that the summary page is
not updating the totals with my changes, but I do not have the file set
on Manual calculation -- it's on Automatic.

I figured out that when I click on one of the cells containing a
formula, I can get it to update if I hit the F2 Key and then hit
Enter.

What's going on? Did I inadvertently change a setting somewhere?

Thanks.


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=552980