Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA function only returns zero's | Excel Worksheet Functions | |||
insert copied row on a protected sheet | Excel Discussion (Misc queries) | |||
GETPIVOTDATA returns #REF error | Excel Worksheet Functions | |||
When Copying a sheet, the whole workbook gets copied | Excel Discussion (Misc queries) | |||
GetpivotData returns a #REF! error | Excel Worksheet Functions |