![]() ![]() In the list of connections, select the connection you want, and then click Open. To reuse or share an existing connection, use a connection from Connections in this Workbook. On the Connections tab, in the Show box, keep All Connections selected, or pick the connection category that has the data source you want to connect to. In the Create PivotTable dialog box, under Choose the data that you want to analyze, click Use an external data source. Here’s how to create a PivotTable by using an existing external data connection: In that case, you’ll connect to the external data source, and then create a PivotTable to summarize, analyze, explore, and present that data. But sometimes it’s hard to know where to start, especially when you have a lot of data that is stored outside of Excel, like in a Microsoft Access or Microsoft SQL Server database, or in an Online Analytical Processing (OLAP) cube file. ![]() Lessīeing able to analyze all the data can help you make better business decisions. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |