PDA

View Full Version : Pivot Table Drilldown



PegLegPete
02-25-2009, 08:53 AM
Hi,

In Excel 2007, if you double-click a data cell in a pivot table, it "drillsdown" on that data cell. In other words, a new worksheet pops up that lists all the datarows which were used to create that data cell in the pivot table (aka, what was summarized).

My question is for anyone who has worked with this feature.

My pivottable's data source is an SQL server, and the query returns a LOT of rows. I have functionality to use the drilldown sheets to let users flag certain rows (which writes a flag back to the database for that row).
SO, my question is: is there anyway to refresh the rows for a given drilldown view without refreshing the entire pivot table.

Our query is so large it is extremely inefficient and nearly unreliable to have to refresh the entire pivot table.

Thanks for any help you can provide,
-Peter

david000
02-26-2009, 01:12 PM
Awesome tutorial:
http://datapigtechnologies.com/ExcelMain.htm

The direct link to the flash movie:
http://datapigtechnologies.com/flashfiles/pivot3.html

PegLegPete
02-27-2009, 08:51 AM
Thanks for your reply, David.

Your videos are really nice, even if they don't answer my question :)