QueryLink and Excel PivotTables
Last Updated: November 2, 2021 4:52:43 PM PDT
Give feedback
With QueryLink you can download data directly into an Excel PivotTable.
Features
- Creating: QueryLink automatically defines and creates a PivotTable when you choose the data you want.
- Downloading: To download the data, select "Excel 2000/XP PivotTable" from the drop down list at the bottom of Query pages.

Sample PivotTable
Need more information? Learn about using Excel PivotTables with Microsoft's tutorial or attend the Advanced Microsoft Excel class offered through UC Learning Center.
To report an incident or suggest an enhancement, submit a service request to ACT-DBWAREHOUSE@ucsd.edu.
For any general Data Warehouse related questions or comments, e-mail ITS-DATAWAREHOUSE@ad-ucsd.edu.
For any general Data Warehouse related questions or comments, e-mail ITS-DATAWAREHOUSE@ad-ucsd.edu.