Cookie question with web query to password protected site

[pierce.brockman]

My web queries to sites which require a login no longer seem to
work. In the past, if I was logged on to the site in a browser, then
excel could retrieve data from that site's pages. Now, the excel
program retrieves the login page of the site, as if I went to the
browser and tried to go to the page witout loggin in the first time.
Any thoughts on what I am doing wrong?

 

[Jim Gordon MVP]

Hi,

Excel may be using settings and cookies from your default web browser. Have
you changed the browser's cookie settings?

-Jim Gordon
Mac MVP

My web queries to sites which require a login no longer seem to
work. In the past, if I was logged on to the site in a browser, then
excel could retrieve data from that site's pages. Now, the excel
program retrieves the login page of the site, as if I went to the
browser and tried to go to the page witout loggin in the first time.
Any thoughts on what I am doing wrong?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[pierce.brockman]

The cookie settings are the same as they have always been. It seems
that when excel is tryiung to do the web page access, it is not
returning the current cookie to the site that my default browser has
stored (just guessing). In the past, I have always had to log on to
the web site through the browser first to make these work. Any othe
thoughts??

 

[Jim Gordon MVP]

Hi,

It used to work fine in Internet Explorer, but IE is a dead beast.

Do you have a URL we can play with?

-Jim

The cookie settings are the same as they have always been. It seems
that when excel is tryiung to do the web page access, it is not
returning the current cookie to the site that my default browser has
stored (just guessing). In the past, I have always had to log on to
the web site through the browser first to make these work. Any othe
thoughts??

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[pierce.brockman]

I am using Safari as my defaul;t browser. I cannot give you the
URLs that I am using because you need an account an password to make
it work and they are subscription sites. I will try to create an
example with a public site and share that with you.

Thanks,
Pierce

Hi,

It used to work fine in Internet Explorer, but IE is a dead beast.

Do you have a URL we can play with?

-Jim

Quoting from "(e-mail address removed)" <[email protected]>, in
article (e-mail address removed), on [DATE:

The cookie settings are the same as they have always been. It seems
that when excel is tryiung to do the web page access, it is not
returning the current cookie to the site that my default browser has
stored (just guessing). In the past, I have always had to log on to
the web site through the browser first to make these work. Any othe
thoughts??

Hi,
Excel may be using settings and cookies from your default web browser. Have
you changed the browser's cookie settings?
-Jim Gordon
Mac MVP
Quoting from "(e-mail address removed)" <[email protected]>, in
article (e-mail address removed), on [DATE:
My web queries to sites which require a login no longer seem to
work. In the past, if I was logged on to the site in a browser, then
excel could retrieve data from that site's pages. Now, the excel
program retrieves the login page of the site, as if I went to the
browser and tried to go to the page witout loggin in the first time.
Any thoughts on what I am doing wrong?
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP infohttp://mvp.support.microsoft.com/