| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.setup
|
|||
|
|||
Disable automatic GETPIVOT
Whenever I reference to a field in a pivot table I get the
"GETPIVOTDATA....." worksheet function. This would normally be OK but this is an Absolute reference and I can't figure out how to get it to make it a relative reference. The only way I can do it is by taking out the formula and manually entering the cell reference - ie "A1". Is there any way the GETPIVOT function can be turned off?? Thanks Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable automatic GETPIVOT | Setting up and Configuration of Excel | |||
| Disable Update Automatic Links | Excel Discussion (Misc queries) | |||
| How can I disable the automatic column breaks in Excel? | Excel Discussion (Misc queries) | |||
| Allow user to disable automatic hyperlink generation in Excel. | Excel Discussion (Misc queries) | |||
| Is there any way to disable the "getpivotdata" automatic formula? | Excel Worksheet Functions | |||
Threaded Mode
