# Microsoft Excel Web Queries

**URL:** <https://boards.straightdope.com/t/microsoft-excel-web-queries/676934>\
**Category:** Factual Questions\
**Created:** [December 22, 2013, 3:16am UTC](https://boards.straightdope.com/t/microsoft-excel-web-queries/676934 "2013-12-22T03:16:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\
**Post date:** [December 22, 2013, 3:16am UTC](https://boards.straightdope.com/t/microsoft-excel-web-queries/676934/1 "2013-12-22T03:16:53Z")

</div>

using Excel 2007

Is there a way to change the default web page in the “Get External Data from Web” when importing data from a web page.

Every time I use this function is goes to some AOL page that has no recognizable data to import.

I know I can do it with my own VB program, but I am hoping for an easier way.

---

<div class="post-metadata">

**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\
**Post date:** [December 22, 2013, 3:29am UTC](https://boards.straightdope.com/t/microsoft-excel-web-queries/676934/2 "2013-12-22T03:29:40Z")

</div>

I think you edit the data sources like so:

> **[Microsoft Support](https://support.microsoft.com/en-us?correlationid=1fd35908-db11-4825-9ae0-a0f789c9dd06&ui=en-us&rs=en-us&ad=us)**
>
> Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft 365, Windows, Surface, and more.

---

<div class="post-metadata">

**Author:** ![Disgscen](https://avatars.discourse-cdn.com/v4/letter/d/f05b48/32.png) [@Disgscen](https://boards.straightdope.com/u/Disgscen)\
**Post date:** [December 23, 2013, 6:55pm UTC](https://boards.straightdope.com/t/microsoft-excel-web-queries/676934/3 "2013-12-23T18:55:04Z")

</div>

It uses the default home page from your internet options.

The way to change this differs based on the system you’re using, but since it’s basically an instance of Internet Explorer, going to IE settings will work.

---

<div class="post-metadata">

**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\
**Post date:** [December 24, 2013, 3:36pm UTC](https://boards.straightdope.com/t/microsoft-excel-web-queries/676934/4 "2013-12-24T15:36:07Z")

</div>

> [@Disgscen](#):
>
> It uses the default home page from your internet options.
> 
> The way to change this differs based on the system you’re using, but since it’s basically an instance of Internet Explorer, going to IE settings will work.

This solved my problem thanks. I don’t use IE at all anymore, its so slow. Changed its home page without a lot of graphics.

Thanks.
