Notice: Trying to access array offset on value of type null in /home/forge/wiki.dataself.com/mediawiki/includes/profiler/SectionProfiler.php on line 99

Notice: Trying to access array offset on value of type null in /home/forge/wiki.dataself.com/mediawiki/includes/profiler/SectionProfiler.php on line 99

Notice: Trying to access array offset on value of type null in /home/forge/wiki.dataself.com/mediawiki/includes/profiler/SectionProfiler.php on line 100

Notice: Trying to access array offset on value of type null in /home/forge/wiki.dataself.com/mediawiki/includes/profiler/SectionProfiler.php on line 100

Notice: Trying to access array offset on value of type null in /home/forge/wiki.dataself.com/mediawiki/includes/profiler/SectionProfiler.php on line 101

Notice: Trying to access array offset on value of type null in /home/forge/wiki.dataself.com/mediawiki/includes/profiler/SectionProfiler.php on line 101
Excel PivotTable from SQL Table or View - DataSelf Knowledge Base

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.

Retrieved from "https://wiki.dataself.com/index.php?title=Excel_PivotTable_from_SQL_Table_or_View&oldid=426"

Category:

Microsoft Excel

Excel PivotTable from SQL Table or View

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools