Breaking Formulas using Pivot Table

[DtTall]

I have Tab1 that has data in it in the form of a pivot table. I then
have another sheet, Tab2, that pulls data from Tab1. This all works,
but when I try to copy Tab2 into a new workbook (so that I can e-mail
only that tab) a bunch of my formulas in Tab2 fail. If I refresh the
pivot tables they work again or if I do a Replace "=" with "=" it
seems to trick it into working (but some percent formatting changes to
dollar formatting for some reason).

I just want to know if there is an easy way to make the new workbook
without breaking the formulas in my old one.

Thanks in advance!

David

 

[Dave Peterson]

Could you just paste special|values into the new worksheet in that new workbook?