Do you love the Excel GetPivotData formula, that appears automatically, when you click on a pivot table value? Or do you want to know how to turn that annoying setting off? In the two videos below, see how to turn GetPivotData off or on, and see an enhanced formula, that pulls data from a specific pivot table in your workbook.
Turn GetPivotData Formula Off
The most common question that I get about the GetPivotData formula is, “What is this weird formula, and how do I turn it off?”
If that’s your question too, this short video has the answer for you. You’ll see how to turn this setting off or on, and there are written steps on the GetPivotData page on my Contextures site.
NOTE: This is an application-level setting, and will affect ALL Excel files that you open on your computer.
Video Timeline
- 00:00 Automatic GetPivotData formula
- 00:24 Copy down GetPivotData formula
- 00:38 Turn Off GetPivotData feature
- 01:01 Test Cell Link
- 01:18 Turn On GetPivotData feature
Select Specific Pivot Table in GetPivotData
If you love the GetPivotData function, the video below shows a handy formula that lets you select data from a specific pivot table in your workbook.
In this example, there are multiple copies of a pivot table in the workbook, on three different sheets. I combined the GetPivotData function with the Excel INDIRECT function, to pull values from a specific pivot table, based on its Region name.
Watch this 4-minute video to see the steps, and the written details are on the GetPivotData page on my Contextures site.
Video Timeline
- 00:00 Worksheets and Pivot Tables
- 00:50 Dashboard Formula
- 02:07 Add INDIRECT Function
- 03:28 Test Dashboard Drop Down
Download the Sample File
For more GetPivotData function examples, and to download the sample file, visit the GETPIVOTDATA function page on my Contextures website.
The zipped Excel file is in xlsx format, and does not contain any macros.
__________________________
Excel GetPivotData Formula Love It or Turn It Off
__________________________