• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint