Connect/ link to a worksheet

[BittenApple]

Hello all,

I have a summary tab which is summary of a pivot table with lots of slicers. I want to link to this sheet and get the filtered value rather than unfiltered data. I linked access to that external data (Excel workbook/ worksheet), I saw that filters were being shown as all in the top rows of the linked table; I realized that I had linked to all data not filtered data only. How can I make the connection to connect to the filtered data only?



Regards,
tibtib,

[HansV]

I don't think that is possible. If you want to filter the data, you'll have to do so in a query in Access.

[BittenApple]

Thanks!!