Copy formula

[Guest]

I was trying to copy-paste a simple formula to calculate the rest of the
cells in a column, the problem is that when I try to paste the formula it
pastes the values from the original cell. even though in that original
formula the values are not absolute, there are no $ sign what so ever!
I tried typing in the function manually in the remaining cells one by one
and in that case it works but it will take a very long time for me to finish
my work. So can any one please tell me why copying the formula or auto fill
is not working properly and acting as if the values are absolute even though
its not.
Thank you in advance

 

[Peo Sjoblom]

Look under tools>options>calculation, make sure it is set to automatic


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Gord Dibben]

Tools>Options>Calculation.

Turn on "automatic" mode.


Gord Dibben MS Excel MVP

 

[Guest]

Thank you so much. the problem is solved now

Look under tools>options>calculation, make sure it is set to automatic


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

Thks for your help

--
Thank You From.02Nanny

Tools>Options>Calculation.

Turn on "automatic" mode.


Gord Dibben MS Excel MVP

 

[Guest]

Thks for your help

--
Thank You From.02Nanny

Tools>Options>Calculation.

Turn on "automatic" mode.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks for the post. This also solved the problem for me.