I have a pivot table that retrieves data from an Access Database. It has
enough data to show some trends.

Let's say that someone see a trend that may indicate a problem, so they want
to drill deeper into it. Is it possible to build the query for the Pivot
table to then go and retrieve more info from the database?

The goal is to keep the spreadsheet from growning to large due to carrying a
lot of data that may not be need all the time.

Thoughts?