When I open Data > from Web the URL is already there and is sometime not available, so I can't change the URL to what I want it to be to actually run a query. Where is this default URL hidden and how can I delete it or change it to something else?
When I open Data > from Web the URL is already there and is sometime not available, so I can't change the URL to what I want it to be to actually run a query. Where is this default URL hidden and how can I delete it or change it to something else?
maybe Data - Recent sources - Right click - Remove from list
The "default" URL pops up from selecting Data > From Web. There is no option for Data > Recent Sources in Excel 2010. I also checked Data > Existing Connections, that URL isn't there.
Sorry mate but you'll need to wait for someone who has Ex2010.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks