Add a button to the Gemini tab to refresh the source data AND Gemini PivotTables
In much of the work I do for clients, a typical workbook would have several PivotTables (many used as source data for dashboard style charts). A single button refreshes them all from the source. A good proportion of these clients don't run SharePoint (I do promote the use of SharePoint where possible).
Gemini doesn't currently support refreshing data from the source, but a Data Refresh button will be added to the Gemini client tab in CTP3. However, each Gemini PivotTable must be updated manually. It should be possible for the Gemini client to update the data source and all PivotTables in one operation.
Upvotes: 0<=-=Aug 26 2009 11:43AM=-=>
Hi Colin — Thanks for this great feedback!