+ Reply to Thread
Results 1 to 4 of 4

excel 2010 why does my web query have a default url and how do I change it

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Aiken, SC
    MS-Off Ver
    Excel 2010
    Posts
    3

    excel 2010 why does my web query have a default url and how do I change it

    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?

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: excel 2010 why does my web query have a default url and how do I change it

    maybe Data - Recent sources - Right click - Remove from list
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    11-05-2012
    Location
    Aiken, SC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: excel 2010 why does my web query have a default url and how do I change it

    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.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: excel 2010 why does my web query have a default url and how do I change it

    Sorry mate but you'll need to wait for someone who has Ex2010.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change Default Browser for Excel Web Query
    By XOR LX in forum Excel General
    Replies: 16
    Last Post: 04-24-2021, 07:32 AM
  2. Change Default Colors in Excel 2010 Chart Series?
    By parodytx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2015, 12:07 PM
  3. Excel 2010 - change default chart color order
    By robhumbug in forum Excel General
    Replies: 3
    Last Post: 04-07-2015, 01:47 AM
  4. Change default pie chart colors in recorded macro 2010
    By tutv088 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2014, 10:35 AM
  5. Default template in Excel 2010
    By kernitoo in forum Excel General
    Replies: 1
    Last Post: 11-13-2013, 04:50 AM
  6. How to change default program for web query
    By davidman1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2013, 08:51 AM
  7. Replies: 0
    Last Post: 06-20-2012, 06:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1