formula locked

C

chum

Hello,

this is the 2nd time that this happens to me:
I have an excel table and want to apply the same formula to the whol
table, however the 1st value occurs in all others cells as well.
Here I want to calculate the frequency but get the result from the 1s
line in the others lines as well.
It looks like the cells are locked, but I checked the security and i
is fine.

Any ideas ?

Thanks
 
B

Bondi

Hi,

Maybe you have absolute references in the first cell. Like $A$1
If you remove the $-signs and copy down the formula it might work.

Regards,
Bondi
 
C

chum

Hello,

I did not put any $ sign, usually when I scroll down excel updates
automatically the calculation ;
if I click again in one of the cell, I can see that the formula has
been updated, but the result's calculation is the same as the 1st one,
and to get the correct I have to click enter in each cell, weird isn't
it ?

thanks
 
B

Bondi

Hi,
Strange stuff indeed..
Is the calculations set to manual?
What if you press F9?

Regards,
Bondi
 
B

Bondi

Hi,

It forces calculation. If you go to Tools -> Options and select the
Calculations tab you can mark the Automatic Calculation option.
I think yours might be on the Manual Calculations option.

Regards,
Bondi
 
C

chum

Hi Bondi,

thanks a million !
you are right, my settings were on manual calculations, now I change
it.

Cheers,
Chu
 
Top