Share via

Powerpivot - "some properties cannot be changed because this connection was modified using the powerpivot add-in"

  • Article

Question

Wednesday, December 17, 2014 9:58 PM

My company recently changed servers and I cannot change the connection string settings in Excel 2013 > Data>Connections.  All boxes are greyed out and I get the message "some properties cannot be changed because this connection was modified using the powerpivot add-in". I can change the setting in > Existing Connections in Powerpivot however, I still cannot refresh.

I have read about other users that have had this issue.  Are there ways around this as I don't want to re-create my data model as it will be labor intensive.  I have tried switch the connection with VBA that I found on the internet however, had no success.

Any help would be greatly appreciated. 

Thanks

John

All replies (2)

Thursday, December 18, 2014 10:51 AM âś…Answered

Hi John,

Based on my research, this is a limitation in PowerPivot for Excel. For more information about this issue, see Updating OData connections in Excel for different PWA instances.

To work around this issue, please follow these steps below:

  1. Click the PowerPivot Tab. 
  2. Click Manage button.
  3. In the Home pane, click Get External Data, and then click Existing Connections. 
  4. Select the connection, and then select Edit. 
  5. Change the Data Feed Url or click Advanced, and then edit it. 
  6. Save the changes and then refresh the workbook.   

Thanks,
Katherine Xiong

Katherine Xiong
TechNet Community Support

Tuesday, February 16, 2016 10:53 PM

How after modifying the odc can i export it to sharepoint?  The option to export is grayed out.