View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to Paste Link A Formula

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