Hmmm, I found from other posts that it seems the Find/Replace is the only way
to do it. I can't believe that there isn't a way in Excel to tell it to copy
and paste exactly. Mabey holding down a certain key on the keyboard, mabey
standing on your head while pasting??

"Ivano" wrote:

Hi,
I have a bunch of forumla's in a worksheet and when I copy either the tab or
select the entire worksheet and paste it into a new workbook it always
references the originals worksheet. How can I copy and past formula's from
one worksheet into another workbook exactly the way it is. Esentially an
exact clone.

Thanks