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

Editing your data connection
There may be times when you need to edit your source data connection after you've already created
it. Unlike refreshing, where you simply take another snapshot of the same data source, editing the
source data connection allows you to go back and reconfigure the connection itself. Here are a few
reasons you may need to edit your data connection:
➤ The location or server or data source file has changed.
➤ The name of the server or data source file has changed.
➤ You need to edit your login credentials or authentication mode.
➤ You need to add tables you left out during initial import.
In the Power Pivot window, click the Home tab and click the Existing Connections button. The
Existing Connections dialog box shown in Figure 4-23 opens. Your Power Pivot connections are under
the Power Pivot Data Connections subheading. Select the data connection that you need to edit.
Figure 4-23: Use the Existing Connections dialog box to reconfigure your
Power Pivot source data connections.