Looking Ahead
In this chapter, you saw how to establish external data sources with DSN files. The DSN file contains information about the path to, and name and type of the external data source.
You saw how to refresh data ranges and pivot tables automatically, when the workbook opens, and by means of VBA code when you want to exert greater control over the refresh process.
And you saw how to use Microsoft Query to guide you through the process of pointing queries at the data source. This was necessarily a brief overview, but Chapter 5, “Using Microsoft Query,” takes you through the process in considerably more detail.
Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
