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

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


DtTall wrote:
>
> 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