Strange Calculation issue

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.

Please check Format Cells.
Select one or range of fomula cell,Right Click, Format Cells, Number tab.
Category: change to general.

Hope it may help.

Best Regards
Bluesky


"LACA" wrote:

>
> 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
>
>