Make a Web page redirect queries
If you are a Web page author, you can increase the reliability of the data users retrieve from your page by having Web queries from Microsoft Excel redirected to a data source such as XML.
-
Include the Microsoft Office namespace declaration in the opening HTML tag of your Web page:
<HTML xmlns:o="urn:schemas-microsoft-com:office:office”>
-
In the body of your page, add the following attribute to opening TABLE tags:
<TABLE ... o:WebQuerySourceHRef="http://...>
where the value is a URL (relative or absolute) to which you want to redirect your Web query.
Note Users can bypass redirection on Web pages by checking Disable Web query redirections in the Web Query Options dialog box (New Web Query dialog box).