Refresh and PivotTable with Analysis Services

[Guest]

This behavior refers to Excel 2007.
The Refresh button update all PivotTables linked to a connection (that
connects to cube in Analysis Services). Refresh All works on all
connections.
Is it possible to refresh a single PivotTable without refreshing all
other PivotTables using the same connection?
Thank you

Marco

 

[Guest]

Have you right-clicked within the pivot table and selected refresh that way?
Appeared to work for me.

 

[Guest]

No, it always generate a query for each PivotTable that shares the same
connection. This behavior was different in Excel 2003.
If you want to try:
1) Create a PivotTable using a connection to Analysis Services
2) Create a copy of the Worksheet containing the PivotTable - at this point
you have 2 pivottables sharing the same connection
3) Change the measures and/or the dimensions selected for the second
PivotTable
4) Open SQL Profiler monitoring your Analysis Services server
5) Right-click Refresh on one of the two PivotTables - you will see that the
server receives two queries (one for each PivotTable) instead of one.

I have a customer that was used to create several PivotTables in the same
Excel document and he would like to continue to update single PivotTables
without waiting for all queries each time.

Marco