Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell in a Pivot table
Hi
i am now using Excel 2007 I create a pivot table and outside a pivot i want to compare some of the numbers within the Pivot. When I enter =A5 for instance in another cell the formula becomes GETPIVOTDATA("PL"........ How do i change this so it just references the cell address (so I copy the fomula across lots of other cells. There was effectively a toggle button in old excel but I cannot find it now. Thanks -- Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell in a Pivot table
Hi,
Click in the pivot table and choose PivotTable Tools, Options tab, open the Options drop down in the PivotTable group on the far left and turn off the Generate GetPivotData. If this helps please click the Yes button. -- Thanks, Shane Devenshire "Kevin" wrote: Hi i am now using Excel 2007 I create a pivot table and outside a pivot i want to compare some of the numbers within the Pivot. When I enter =A5 for instance in another cell the formula becomes GETPIVOTDATA("PL"........ How do i change this so it just references the cell address (so I copy the fomula across lots of other cells. There was effectively a toggle button in old excel but I cannot find it now. Thanks -- Kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select a cell in a Pivot table
thank you - could not remember name of command
-- Kevin "ShaneDevenshire" wrote: Hi, Click in the pivot table and choose PivotTable Tools, Options tab, open the Options drop down in the PivotTable group on the far left and turn off the Generate GetPivotData. If this helps please click the Yes button. -- Thanks, Shane Devenshire "Kevin" wrote: Hi i am now using Excel 2007 I create a pivot table and outside a pivot i want to compare some of the numbers within the Pivot. When I enter =A5 for instance in another cell the formula becomes GETPIVOTDATA("PL"........ How do i change this so it just references the cell address (so I copy the fomula across lots of other cells. There was effectively a toggle button in old excel but I cannot find it now. Thanks -- Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a coloumn or row in a Pivot table | Excel Discussion (Misc queries) | |||
When I go to select pivot table it is greyed out? | New Users to Excel | |||
Select Pivot Table | Excel Discussion (Misc queries) | |||
Referencnig a cell to select a value in a Pivot Table Pull-Down Me | Excel Discussion (Misc queries) | |||
Pivot Table help - select pages | Excel Discussion (Misc queries) |