Prev: Heat Map
Next: Excel English to French and French to English
From: Ooi3286 on 8 Apr 2010 23:16
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!!
From: Gord Dibben on 9 Apr 2010 11:03
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

On Thu, 8 Apr 2010 20:16:01 -0700, Ooi3286
<Ooi3286(a)discussions.microsoft.com> wrote:

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

 | 
Pages: 1
Prev: Heat Map
Next: Excel English to French and French to English