Loading External Data into Power Pivot - Microsoft Business Intelligence Tools for Excel Analysts - page 88

After you select your target data connection, click either the Edit or Open button, depending on what
you need to change:
➤ Edit: Lets you reconfigure the server address, file path, and authentication settings.
➤ Open: Lets you import a new table from the existing connection. This is handy if you inad-
vertently missed a table during the initial loading of data.