Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve Data to Pivot Table "On Demand"
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve Data to Pivot Table "On Demand"
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. -- Regards Roger Govier "Steve Haack" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
Pivot Table "Data source reference is not valid" error cause? | Excel Discussion (Misc queries) | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Pivot table "Show all data" query | Excel Discussion (Misc queries) | |||
Changing data source in pivot table- "Back" button is disable | Excel Discussion (Misc queries) |