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

  • Question

  • 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

    Wednesday, December 17, 2014 9:58 PM

Answers

  • 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

    Thursday, December 18, 2014 10:51 AM

All replies

  • 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

    Thursday, December 18, 2014 10:51 AM
  • How after modifying the odc can i export it to sharepoint?  The option to export is grayed out.
    Tuesday, February 16, 2016 10:53 PM