Excel PivotTable from SQL Table or View

From DataSelf Knowledge Base
Revision as of 18:40, 2 December 2013 by Dataself (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.