| 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 |
| 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) | |||
Threaded Mode
