Strange Calculation issue

L

LACA

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

Bluesky

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
 
Top