How can I paste link a formula to other worksheet?

The problem is each time, when I updated the formula from original cell,
then the link cell replaced with the same value from original cell, not the
formula.

Thank You.

Ming

I'm not sure what you mean.

You can edit|copy, edit|paste special|Paste Link

Or you can copy the cell and paste it--the formula will adjust according to the
cell's location.

Or you can copy the formula from the formula bar and paste into the formula--and
the formula won't change.



Ming Fang wrote:

How can I paste link a formula to other worksheet?

The problem is each time, when I updated the formula from original cell,
then the link cell replaced with the same value from original cell, not the
formula.

Thank You.

Ming

--

Dave Peterson

When you paste a link to a cell, you are pasting a link to the value in that
cell.

What do you want to appear in the target cell?


Gord Dibben MS Excel MVP


On Thu, 3 Aug 2006 14:08:01 -0700, Ming Fang <Ming
wrote:

How can I paste link a formula to other worksheet?

The problem is each time, when I updated the formula from original cell,
then the link cell replaced with the same value from original cell, not the
formula.

Thank You.

Ming