copying excel cells with formulas

[yaro137]

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

 

[David Biddulph]

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?

 

[yaro137]

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?

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

 

[Dave Peterson]

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

 

[yaro137]

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