Chapter 35: Introducing Power Pivot
35
Editing your data connection
There may be instances where 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. Here are a few reasons that you’ll need to edit a 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 that you left out during the initial import.
In the Power Pivot window, go to the Home tab and click the Existing Connections button.
The Existing Connections dialog box shown in Figure 35.24 will open. Your Power Pivot con-
nections will be under the Power Pivot Data Connections subheading. Choose the data con-
nection that needs editing.
FIGURE 35.24
Use the Existing Connections dialog box to reconfigure your Power Pivot source
data connections.
Once your target data connection is selected, look to the Edit and Open buttons. The button
you click depends on what you need to change.
The Edit button Lets you reconfigure the server address, file path, and authentication
settings.
The Open button Lets you import a new table from the existing connection. This is
handy when you inadvertently missed a table during the initial loading of data.