| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.setup
|
|||
|
|||
|
Disable automatic GETPIVOT
Hi
Take a look at Debra Dalgleish's site for information on the GetPivotData function http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "news.microsoft.com" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.setup
|
|||
|
|||
|
Disable automatic GETPIVOT
Many thanks Roger it worked a treat
Nick "Roger Govier" wrote in message ... Hi Take a look at Debra Dalgleish's site for information on the GetPivotData function http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "news.microsoft.com" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.setup
|
|||
|
|||
|
Disable automatic GETPIVOT
Well, thanks to Debra really, but many thanks for the feedback
-- Regards Roger Govier "news.microsoft.com" wrote in message ... Many thanks Roger it worked a treat Nick "Roger Govier" wrote in message ... Hi Take a look at Debra Dalgleish's site for information on the GetPivotData function http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "news.microsoft.com" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Disable automatic date conversion feature | Excel Worksheet Functions | |||
Linear Mode
