I would suggest that 'Generate GetPivotData' should be toggled off by default
in future releases. Users that are savvy enough to want to use it will know
how to turn it on. My experience that most users (98% of those I work with)
are baffled when they try to use formulas based on the pivot table. They
learned how to use pivot tables in Office 97 and are lost with the advent of
this function.

Valuable. Thanks.

:dozy:


"Lonnie" wrote in message
...
I would suggest that 'Generate GetPivotData' should be toggled off by
default
in future releases. Users that are savvy enough to want to use it will
know
how to turn it on. My experience that most users (98% of those I work
with)
are baffled when they try to use formulas based on the pivot table. They
learned how to use pivot tables in Office 97 and are lost with the advent
of
this function.