Share via

Disable option

Anonymous
2010-05-08T06:46:36+00:00

hi everyone,

genraly in my company we are closing any program that make u able to go online

so

my boss in work gave me a task , but till now i can`t find a solve for it

Task is:

in excel if choose

Data>from web

give you a page that make u able to be online

is there any possible to disable this option

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-05-09T05:31:29+00:00

    Hi you might try something like this:

    Make a Web page redirect a Web query to another data source

    1. Include the Microsoft Office namespace declaration in the opening HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) tag of your Web page:

    <HTML xmlns:o="urn:schemas-microsoft-com:office:office”>

    1. In the body of the Web page, add the following attribute to the opening TABLE, PRE, XMP, LISTING, or PLAINTEXT tag. For example:

    <TABLE ... o:WebQuerySourceHRef="URL">

    where the value is a URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.) (relative or absolute) to which you want to redirect your Web query.

     Note    Users can bypass redirection on Web pages by selecting the Disable Web query redirections check box in the Web Query Options dialog box. You can access this from the New Web Query dialog box.

    --

    If this helps, please click the Yes button.

    Cheers,

    Shane Devenshire

    "ilovemessi" wrote in message news:5134c458-dce1-47d9-9946-7fb05eed25f3...

    hi everyone,

    genraly in my company we are closing any program that make u able to go online

    so

    my boss in work gave me a task , but till now i can`t find a solve for it

    Task is:

    in excel if choose

    Data>from web

    give you a page that make u able to be online

    is there any possible to disable this option

    Cheers, Shane Devenshire

    i really don`t understand this clearly

    can u give more details or example with some images

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-05-09T05:30:30+00:00

    AFAIK it can be only done in Excel 2002 and Excel 2003 by using sytem policy. I am not sure whether you can disable web query in Excel 2007.

    I am unable to find any results for this issue. Will keep you update for sure if i am to find any help on this.

    thanks for trying

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-05-08T18:09:23+00:00

    Hi you might try something like this:

    Make a Web page redirect a Web query to another data source

    1. Include the Microsoft Office namespace declaration in the opening HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) tag of your Web page:

    <HTML xmlns:o="urn:schemas-microsoft-com:office:office”>

    1. In the body of the Web page, add the following attribute to the opening TABLE, PRE, XMP, LISTING, or PLAINTEXT tag. For example:

    <TABLE ... o:WebQuerySourceHRef="URL">

    where the value is a URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.) (relative or absolute) to which you want to redirect your Web query.

     Note    Users can bypass redirection on Web pages by selecting the Disable Web query redirections check box in the Web Query Options dialog box. You can access this from the New Web Query dialog box.

    --

    If this helps, please click the Yes button.

    Cheers,

    Shane Devenshire

    "ilovemessi" wrote in message news:5134c458-dce1-47d9-9946-7fb05eed25f3...

    hi everyone,

    genraly in my company we are closing any program that make u able to go online

    so

    my boss in work gave me a task , but till now i can`t find a solve for it

    Task is:

    in excel if choose

    Data>from web

    give you a page that make u able to be online

    is there any possible to disable this option

    Cheers, Shane Devenshire

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-05-08T17:14:06+00:00

    AFAIK it can be only done in Excel 2002 and Excel 2003 by using sytem policy. I am not sure whether you can disable web query in Excel 2007.

    I am unable to find any results for this issue. Will keep you update for sure if i am to find any help on this.

    Was this answer helpful?

    0 comments