Cannot modify the oData connections in an Excel 2013 PowerPivot workbook
Symptoms
When you try to modify the oData connections in a Microsoft Excel 2103 PowerPivot workbook, you receive the following error message:
Some properties cannot be changed because this connection was modified using the PowerPivot Add-In.
Cause
This is a limitation in PowerPivot for Excel.
Workaround
To work around this issue, follow these steps:
- 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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for