autocalculate doesn't work even with formula .

  • Thread starter Thread starter Ooi3286
  • Start date Start date
O

Ooi3286

I have been using the same worksheet for past 1 year.
Last week, when I edit the worksheet by input new data into it, I realise
that :
1. The "Total" does not add up the sums of 2 cells automatically, even
though the "A1 + B1" formulation is still in the cell.
2. I have auto-link sheet 1 cells into sheet 2 in different layout to suit
my final output design. But even I paste the cells in the designated area in
sheet 1, my final output does not automatically show the new data I have
input into sheet 1. Only way to "show in the final output" correctly, is to
save the file, close it and reopen.

Does anyone have this problem?

Please help!!
 
Reset calculation mode to "Automatic".

One of your workbooks set it to manual and now all workbooks open in that
mode.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top