Excel PivotTable from SQL Table or View

From DataSelf Knowledge Base
Jump to navigation Jump to search

Be aware that by default, Excel 2010 options are set to "Save source data with file". Meaning that it will NOT refresh the data from the SQL source when you select "refresh data". Use Pivot table Options > Data tab to unselect this.