Use External Data Source For Pivottable. Get A Free Trial. On the Data tab click New Database Query Click From Database.
On the left click the arrow next to the server to see the. I am using SQL Server 2012 and creating a VIEW. Anzeige Visualize Your Data in Diverse Ways Go Beyond Excel.
You can import data into your Pivot Table from the following data sources.
Each row consists of an SQL connection string with the remaining elements as the query string broken down into 255-character segments. This PivotTable connects to an external data source thats not supported in this version of Excel. Anzeige Visualize Your Data in Diverse Ways Go Beyond Excel. It is using ViewQueryodc.