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 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 |