On the Data tab, click New Database Query You can use an external data source, but it depends on the type of source. Use an external data source to create a PivotTable In this case, you connect to the external data source first, and then use a PivotTable to summarize, analyze, explore, and present that data. Sometimes you need a PivotTable for data that is stored outside of Excel, like in a database. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac More.
