Very simple function not working

[ScoTTyBEEE]

Hi,

I have a list of letters and numbers in B2. I am putting in the formul
=b2 in the cell next to it and dragging the formula down. The formul
looks fine if I go into each cell and has copied correctly i.e =b3, =b
e.t.c but all the cells show the info from b2?!?!?! if I click the = fo
a non working cell and then ok it calculates it correctly but I hav
thousands of them to do.

Please help!!!

Scott

 

[Niek Otten]

Tools>Options>Calculation, Check Automatic

 

[Guest]

Sounds to me that the Options for Calculation are set to Manual...

Select Tools
Select Options
Select the Calculation Tab
Select the Automatic Radio button

Try it out

 

[swatsp0p]

Please check the setting under Tools>Options>Calculation -- it should be
set to Automatic. Is it?