Rhonda,

Choose the "Paste Link" option.

HTH,
Bernie
MS Excel MVP


"Rhonda" wrote in message
...
Help!

I tried to copy some data from one workbook to another (special paste).
Then I made changes to he initial workbook, when I went back to the
workbook
that I did the special paste - no update. I thought if I did a "special
paste" - once I changed the data in the initial workbook, it will
automatically change in the other workbook?

I thank you in advance for your prompt response.

Rhonda Randolph
Medical University of South Carolina