Retrieve Data to Pivot Table "On Demand"

S

Steve Haack

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?
 
R

Roger Govier

Hi Steve

In order to do a drill down, the data has to be held in the Pivot Cache.
The data does not have to be loaded onto an Excel sheet first, it can be
loaded directly to the Pivot Cache, and even 1 million rows of data can be
loaded into cache in an XL2003 file without the file size getting too big.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Creating a Chart on form from selected data in query. 0
Pivot Table Data Aggregation 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table 0
Pivot Table Mapping 1

Top