It works fine within one spreadsheet but fails when I try to copy a
cell including a formula to a new excel spreadsheet and copies only
the value. Is there a way to force it to copy the formula so it
automatically applies to relative positions of cells containing
values? What I mean by that is if the formulas location is in A2 and
it applies to values in A1,B1 then if I copy it to the new spreadsheet
into say A4 than it will apply to values contained in cells A3,B3.
yaro

How are you doing the copy? Which version of Excel? It ought to work in
the way you describe.
What do you see in the formula bar when you select the cell from which you
are copying?
What do you see in the formula bar in the destination cell into which you
have copied?
--
David Biddulph

wrote in message
...
It works fine within one spreadsheet but fails when I try to copy a
cell including a formula to a new excel spreadsheet and copies only
the value. Is there a way to force it to copy the formula so it
automatically applies to relative positions of cells containing
values? What I mean by that is if the formulas location is in A2 and
it applies to values in A1,B1 then if I copy it to the new spreadsheet
into say A4 than it will apply to values contained in cells A3,B3.
yaro

On 13 Dec, 16:35, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
How are you doing the copy? Which version of Excel? It ought to work in
the way you describe.
What do you see in the formula bar when you select the cell from which you
are copying?
What do you see in the formula bar in the destination cell into which you
have copied?
--
David Biddulph



It's excel 2002. I just right-clicking on the cell that I want to copy
from and choose Copy.
In the formula bar I can see my formula =A1+B1 in the destination I'm
getting only the value
from my A2 cell from the source spreadsheet and no formula at all in
the formula bar.
Thanks
yaro

It sounds like you have two instances of excel running.

Close one workbook (and that instance of excel), then in the remaining instance,
use:
File|open to open the second workbook.

Then try your Copy|paste



" wrote:

It works fine within one spreadsheet but fails when I try to copy a
cell including a formula to a new excel spreadsheet and copies only
the value. Is there a way to force it to copy the formula so it
automatically applies to relative positions of cells containing
values? What I mean by that is if the formulas location is in A2 and
it applies to values in A1,B1 then if I copy it to the new spreadsheet
into say A4 than it will apply to values contained in cells A3,B3.
yaro

--

Dave Peterson

On 13 Dec, 17:02, Dave Peterson wrote:
It sounds like you have two instances of excel running.

Close one workbook (and that instance of excel), then in the remaining instance,
use:
File|open to open the second workbook.

Then try your Copy|paste


Dave Peterson

That works just fine. Thanks for your help.
Most appreciated.
yaro