I have a worksheet with a GETPIVOTDATA command that works perfectly.
When I copy this worksheet to a new worksheet, the GETPIVOTDATA
command returns a value of zero in the cell. However, if I go to the
formula bar on the worksheet with the copied cell that returns the
zero and click on the command text and then click back to a cell, the
GETPIVOTDATA returns the correct value.

What causes this? Is there a way to "recalc" the whole page at once
instead of cell be cell?

Thank you,

Frank Hayes