driller,

Do a paste (which will paste everything, include conditional formatting with
formulas) and then do the pastespecial paste links right after, which will
create the links only.

HTH,
Bernie
MS Excel MVP


"driller" wrote in message
...
Hi Sir Bernie,

I wonder if there is a link that can help us to paste specialpaste link
ALL incldg. cond. format with formula...

regards

--
*****
birds of the same feather flock together..



"Bernie Deitrick" wrote:

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