|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 6th, 2006, 10:27 AM
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
July 6th, 2006, 06:09 PM
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
July 10th, 2006, 10:54 AM
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
July 10th, 2006, 09:19 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Disable automatic expression checking? | Frankenbox | New Users | 2 | March 9th, 2006 05:52 PM |
| How to disable automatic launch of OE 6 at Startup | DeepForestValley | Outlook Express | 2 | March 30th, 2005 05:46 PM |
| Disable automatic line breaks | Alex Ivanov | Outlook Express | 5 | March 15th, 2005 07:11 PM |
| Disable Automatic updates of external Datasources | Sam MacCutchan | Links and Linking | 2 | October 18th, 2004 04:31 PM |
| How to disable automatic deletion of recalled message - part 3 | Novice | General Discussion | 1 | August 25th, 2004 10:55 AM |
Linear Mode
