| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to I exclude GETPIVOTDATA from formulas?
How can I get rid of the GETPIVOTDATA from formulas? I want to create
formulas and be able to copy them with relative references (not absolute) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I exclude GETPIVOTDATA from formulas?
Type in the cell address, rather than clicking on the cell in the pivot table.
HTH, Bernie MS Excel MVP "lthomson" wrote in message ... How can I get rid of the GETPIVOTDATA from formulas? I want to create formulas and be able to copy them with relative references (not absolute) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to I exclude GETPIVOTDATA from formulas?
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html lthomson wrote: How can I get rid of the GETPIVOTDATA from formulas? I want to create formulas and be able to copy them with relative references (not absolute) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
Linear Mode
