Excel PivotTable from SQL Table or View
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.