GETPIVOTDATA returns zero when copied to another sheet

  • Thread starter Thread starter Frank Hayes
  • Start date Start date
F

Frank Hayes

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
 
Hi,

Is the source or target range formatted as text? Is your workbook in manual
calculation mode? Choose Tools, Options, Calculation and make sure Automatic
is checked.

You can recalculate by pressing F9. or clicking the Calc Sheet button in
the above dialog box.

F9 Recalculate all open workbooks
Shift+F9 Calculate active worksheet
Ctrl+Alt+F9 Recalculates all open workbooks regardless of changes - Full
recalc
Ctrl+Alt+Shift+F9 Rechecks dependent formulas and then calculates all cells
in all open workbooks, including cells not marked as needing to be calculated.
 
Back
Top