software

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 advanceLook under toolsgt;optionsgt;calculation, make sure it is set to automatic--

Regards,

Peo Sjoblom

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

Turn on quot;automaticquot; mode.Gord Dibben MS Excel MVP

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

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

quot;Peo Sjoblomquot; wrote:

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

Thks for your help

--
Thank You From.02Nannyquot;Gord Dibbenquot; wrote:

gt; Toolsgt;Optionsgt;Calculation.
gt;
gt; Turn on quot;automaticquot; mode.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 25 Apr 2006 13:45:02 -0700, fofo gt; wrote:
gt;
gt; gt;I was trying to copy-paste a simple formula to calculate the rest of the
gt; gt;cells in a column, the problem is that when I try to paste the formula it
gt; gt;pastes the values from the original cell. even though in that original
gt; gt;formula the values are not absolute, there are no $ sign what so ever!
gt; gt;I tried typing in the function manually in the remaining cells one by one
gt; gt;and in that case it works but it will take a very long time for me to finish
gt; gt;my work. So can any one please tell me why copying the formula or auto fill
gt; gt;is not working properly and acting as if the values are absolute even though
gt; gt;its not.
gt; gt;Thank you in advance
gt;
gt;

Thanks for the post. This also solved the problem for me.quot;Peo Sjoblomquot; wrote:

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