GETPIVOTDATA returns zero when copied to another sheet
 

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

GETPIVOTDATA returns zero when copied to another sheet
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Frank Hayes" wrote:

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

GETPIVOTDATA returns zero when copied to another sheet
 

Ctrl+Alt+F9 did the trick. Thank you for your help.

Frank

"Shane Devenshire" wrote in
message ...
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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Frank Hayes" wrote:

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