Linking to a Pivot Table

MOB

Well-known Member
Joined
Oct 18, 2005
Messages
1,024
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.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,455
Members
410,612
Latest member
MrACED
Top