MANAGEMENT OF CONNECTIONS TO EXTERNAL DATA

Embodiments of present application treat Connection Information Files contained in an instance of an application, such as a workbook, as independent objects and multiple data objects, such as data summary tables, may link to one Connection Information File. Maintaining Connection Information Files as independent objects within an instance of an application provides the ability to modify a connection to an external data source and have that modification applied to all linked data objects without having to modify each data object individually. Additionally, a user may view a complete list of all Connection Information Files that exist within a workbook and easily add, delete, or modify those Connection Information Files.