If you receive an Excel workbook with a Pivot Table in it and try to use the cells in a formula, you’ve probably seen the GetPivotData reference. GetPivotData has some very good uses, but it can be frustrating if you just want to refer to particular values in a range of cells in a Pivot Table.
With your cursor in the Pivot Table, click the Pivot Table Tools Options contextual tab. You’ll find an Options button on the far left. Click on the dropdown arrow to its right. You’ll find an option to turn off the Generate GetPivotData tool.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/33416/getpivotdata "