Linking to a Pivot Table

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,042
Office Version
  1. 365
Platform
  1. Windows
Hi

I'm not that strong with pivot tables - I have a spreadsheet that I need to link to some other data - at the moment that data is on another spreadsheet and in order to make sense of the data, I have used a simple pivot table as there are 2 variables to search for.

Is it possible to link directly to the pivot table in such a way that even when the data is refreshed or different selections are made etc, the correct data stilll gets pulled accross?

The current way of doing things is to concatenate the 2 variables and do a sumif. I have considered a sumproduct instead but whenever I introduce sumproducts it tends to slow the calcs down dramtaically.

Any suggestions would be appreciated.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

mtb'r

New Member
Joined
Sep 8, 2006
Messages
42
As long as your pivot table is simple, you may want to try using the GETPIVOTDATA function in Excel. It will find the data corresponding to the inputs you select, even if the table is refreshed.
 

Forum statistics

Threads
1,141,012
Messages
5,703,729
Members
421,312
Latest member
Mooncake1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top