Wednesday, October 13, 2010 12:15 PM
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.
Thursday, October 14, 2010 7:44 PM
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
- Marked As Answer by Adrian Grigore Tuesday, October 19, 2010 1:56 PM
Tuesday, October 19, 2010 1:57 PMThanks a lot, John!
Adrian Grigore http://www.logmytime.de