View source for Excel PivotTable from SQL Table or View

← Excel PivotTable from SQL Table or View

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Administrators.

You can view and copy the source of this page.


{{#breadcrumb:MS Excel}}
[[Category:Microsoft Excel]]

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.

Return to Excel PivotTable from SQL Table or View.

Retrieved from "https://wiki.dataself.com/Excel_PivotTable_from_SQL_Table_or_View"