ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula locked (https://www.excelbanter.com/excel-discussion-misc-queries/88024-formula-locked.html)

chum

formula locked
 

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 whole
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 1st
line in the others lines as well.
It looks like the cells are locked, but I checked the security and it
is fine.

Any ideas ?

Thanks !


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=540975


Bondi

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


chum

formula locked
 

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


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=540975


Bondi

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

Regards,
Bondi


chum

formula locked
 

thanks, it works !

do you know why I need to press F9 ?


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=540975


Bondi

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


chum

formula locked
 

Hi Bondi,

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

Cheers,
Chum


--
chum
------------------------------------------------------------------------
chum's Profile: http://www.excelforum.com/member.php...o&userid=34262
View this thread: http://www.excelforum.com/showthread...hreadid=540975



All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com