| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh and PivotTable with Analysis Services
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refresh and PivotTable with Analysis Services
Have you right-clicked within the pivot table and selected refresh that way?
Appeared to work for me. "Marco Russo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refresh and PivotTable with Analysis Services
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 "Sean Timmons" wrote: Have you right-clicked within the pivot table and selected refresh that way? Appeared to work for me. "Marco Russo" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-In functions not available Analysis Services add-in. | Excel Worksheet Functions | |||
| Sharepoint Services -- Need Refresh Option | Excel Discussion (Misc queries) | |||
| Problem connecting to Analysis Services | Excel Discussion (Misc queries) | |||
Linear Mode
