How to Paste Link A Formula

M

Ming Fang

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
 
D

Dave Peterson

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.
 
G

Gord Dibben

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
 
Top