GETPIVOTDATA in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
Thanks!

Nick Hodge said:
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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum of getpivotdata() 0
2007 Excel - GETPIVOTDATA 2
Can getpivotdata use a cell reference? 5
GetPivotData 1
GETPIVOTDATA from OLAP cube - grouped field 0
getpivotdata wildcard? 0
if(iserror()) question 2
getpivotdata doesn't like certain numbers?? 2

Back
Top