Very simple function not working

S

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
 
J

Joe Mac

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
 
S

swatsp0p

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