Thursday, July 12, 2012 7:27 AM
I need to know if it is possible to disable the automatic data refresh when I work inside PowerPivot window opened in Excel 2010. If possible, I could work in an off-line manner after the data loading.
Thursday, July 12, 2012 8:21 AM
when you select a PowerPivot chart in Excel you get the PivotChart Tools ribbon, on the Analyze section select the drop down arrow under the Refresh icon and then Connection Properties. In here you will see the Refresh control options.
Thursday, July 12, 2012 9:52 AM
Hi, I cannot see any option to disable the data refresh.
However I'm talking about data refresh from data source connections to PowerPivot tables, not to PowerPivot tables to a chart or a pivot table.
Wednesday, July 18, 2012 5:52 AMModerator
We cannot manually cancel a data refresh operation once it starts, but we can disable the schedule in advance to prevent it from running. For more information about how to disable data refresh for a specific workbook, see Schedule PowerPivot Data Refresh. For more information about how to turn off data refresh on the server, see Configure Dedicated Data Refresh or Query-Only Processing.
TechNet Community Support
Wednesday, July 18, 2012 7:34 AM
Hi Bin, but I'm not to refer to a PowerPivot published on SharePoint.
I'd like to know if it is possible to disable the data refresh for a PowerPivot workbook opened in an Excel client.