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