GETPIVOTDATA in Excel 2007

K

Kirk P.

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

Nick Hodge

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
[email protected]
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
Top