Update OLE DB Connection not possible

[tigitago]

Hello
We changed the power pivot table etc. behind the Excel worksheet. At the moment we read in the new data the worksheet was updating. But we are not able to change the settings in the worksheet to the new Stored Procedure (it shows as disabled and not changeable) as we want to refresh it from there. The connection to the "old" table is still in there and it seems that is not possible to change?
Thanks for helping

 

[tigitago]

here a link for a more detailed description but this is not the solution. Somehow it needs to be changed in Excel Worksheet not Power Pivot as described:

KB2955369 Die oData-Verbindungen in einer Excel-2013 PowerPivot-Arbeitsmappe kann nicht geändert werden. Cannot modify the oData connections in an Excel 2013 PowerPivot workbook