Some properties cannot be changed because the connection was modified using the PowerPivot Add-In.
- You click the PowerPivot Tab.
- You click Home, click Get External Data, and then click Existing Connections.
- You select the connection, and then select Edit.
- You change the Data Feed Url or click Advanced, and then edit it.
- You save the changes and then refresh the workbook.
Article ID: 2955369 - Last Review: 28 Apr 2014 - Revision: 1