Changing data feed URL

Question

Hi,

 

The website we are developing comes with an OData data feed which will be consumed by Excel PowerPivot. I'd like to create a relatively complex workbook for the API and offer that as a boilerplate project to my customers.

 

While I am working on the workbook it should connect to our development web server. Before giving the workbook to our customers, I need to change the URL for the data feed so that it points to our production web server. Is there any way to change the URL? I only know how to create new tables based on different feeds, but that way my excel spreadsheets still point to my development server tables.

 

Thanks,

 

Adrian

Answer 1

Adrian, you can change the URL as follows:

- On the Design ribbon tab, choose Existing Connections

- Select the data source connection and click Edit

- Change the URL and click OK

Answer 2

Thanks a lot, John!

---

Adrian Grigore http://www.logmytime.de