| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA in Excel 2007
How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it
in previous versions, but this new interface has got me baffled and Excel Help is no help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GETPIVOTDATA in Excel 2007
Kirk
While in you pivot table you will get the 'Pivot Table Tools' contextual tabset. this has two tabs (Options and Design), click on Options and then on the far left 'PivotTable' group, select options and un-check 'Generate GetPivotData' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it in previous versions, but this new interface has got me baffled and Excel Help is no help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GETPIVOTDATA in Excel 2007
Kirk
While in you pivot table you will get the 'Pivot Table Tools' contextual tabset. this has two tabs (Options and Design), click on Options and then on the far left 'PivotTable' group, select options and un-check 'Generate GetPivotData' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it in previous versions, but this new interface has got me baffled and Excel Help is no help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GETPIVOTDATA in Excel 2007
Thanks!
"Nick Hodge" wrote: Kirk While in you pivot table you will get the 'Pivot Table Tools' contextual tabset. this has two tabs (Options and Design), click on Options and then on the far left 'PivotTable' group, select options and un-check 'Generate GetPivotData' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it in previous versions, but this new interface has got me baffled and Excel Help is no help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GETPIVOTDATA in Excel 2007
Thanks!
"Nick Hodge" wrote: Kirk While in you pivot table you will get the 'Pivot Table Tools' contextual tabset. this has two tabs (Options and Design), click on Options and then on the far left 'PivotTable' group, select options and un-check 'Generate GetPivotData' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it in previous versions, but this new interface has got me baffled and Excel Help is no help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GETPIVOTDATA in Excel 2007
No Probs
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... Thanks! "Nick Hodge" wrote: Kirk While in you pivot table you will get the 'Pivot Table Tools' contextual tabset. this has two tabs (Options and Design), click on Options and then on the far left 'PivotTable' group, select options and un-check 'Generate GetPivotData' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it in previous versions, but this new interface has got me baffled and Excel Help is no help. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
GETPIVOTDATA in Excel 2007
No Probs
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... Thanks! "Nick Hodge" wrote: Kirk While in you pivot table you will get the 'Pivot Table Tools' contextual tabset. this has two tabs (Options and Design), click on Options and then on the far left 'PivotTable' group, select options and un-check 'Generate GetPivotData' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Kirk P." wrote in message ... How do I disable the GETPIVOTDATA formula in Excel '07? I know how to do it in previous versions, but this new interface has got me baffled and Excel Help is no help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GETPIVOTDATA....Excel 2000....Desperation! | Excel Worksheet Functions | |||
| GetPivotData in excel for Mcintosh | Excel Worksheet Functions | |||
| GETPIVOTDATA Excel 2003 Problem | Excel Discussion (Misc queries) | |||
| getpivotdata function with Excel 2000 | Excel Discussion (Misc queries) | |||
| Dynamic Getpivotdata in Excel XP | Excel Worksheet Functions | |||
Linear Mode
