Copy formula
 

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

Copy formula
 

Look under toolsoptionscalculation, make sure it is set to automatic


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"fofo" wrote in message
...
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

Copy formula
 

ToolsOptionsCalculation.

Turn on "automatic" mode.


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 13:45:02 -0700, fofo wrote:

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

Copy formula
 

Thank you so much. the problem is solved now :-)

"Peo Sjoblom" wrote:

Look under toolsoptionscalculation, make sure it is set to automatic


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"fofo" wrote in message
...
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

Copy formula
 

Thks for your help

--
Thank You From.02Nanny


"Gord Dibben" wrote:

ToolsOptionsCalculation.

Turn on "automatic" mode.


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 13:45:02 -0700, fofo wrote:

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

Copy formula
 

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


"Peo Sjoblom" wrote:

Look under toolsoptionscalculation, make sure it is set to automatic


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"fofo" wrote in message
...
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