First paste then paste link
Ctrl+V, then
Alt, E, S, L

On Wed, 2 Mar 2005 09:45:04 -0800, Elizabeth
wrote:

i am trying to link one cell in worksheet 1 to another cell in worksheet 2
but the formatting is not copying over.