Data from Pivot table breaks

[DtTall]

Basically I have a tab that I pull in data from a pivot table. When I
copy out a sheet to a new workbook, no matter which sheet I copy, some
formulas break. Nothing is wrong with them because all I have to do to
get them to work is do a little trick of Replace "=" with "=" and it
is all good. I also found that if I refresh each of the pivot tables
(six or more) I have, it will also make the formulas work again.

Is there anyway around this strange phenomenon?

Thanks,
David

Note: It is not the copied page the breaks but other pages in the
workbook. Which page I copy doesn't matter.