IE or Excel caching data?

[tdeniston]

I am accessing a website that generates csv reports for many different
facilities I service. The csv files all have the same name and, subsequently,
the same URL. There is some kind of backend script that generates these files
and opens them in Excel for me automatically when I click the appropriate
link.

The first time I click the link, it works fine. The second time, I click the
link that is associated with a different facility, but the data for the first
facility still shows up in the csv Excel file. I have played with IE's cache,
cookies, history, and advanced settings to no avail. I could not find a
setting for any kind of cache in Excel.

I am using Windows XP SP2 (with all updates) and Office XP (2002, with all
updates). Another strange thing is that I have several other machines in my
office that are set up with the same software that are experiencing this
issue. However, the helpdesk for the site I am using said they cannot
replicate the issue and therefore are unable to help me. I called another
helpdesk and they are also unable to help me. So, help!

UPDATE: I have uninstalled and reinstalled Office 2002 (XP) and it is still
doing this.

[jaf]

If the filename and URL are the same then you are always accessing the same
file.
Unless the contents of the file change between clicks the file will always
contain the same data.

John

"tdeniston" <[email protected]> wrote in message
news:[email protected]...
> I am accessing a website that generates csv reports for many different
> facilities I service. The csv files all have the same name and,
subsequently,
> the same URL. There is some kind of backend script that generates these
files
> and opens them in Excel for me automatically when I click the appropriate
> link.
>
> The first time I click the link, it works fine. The second time, I click
the
> link that is associated with a different facility, but the data for the
first
> facility still shows up in the csv Excel file. I have played with IE's
cache,
> cookies, history, and advanced settings to no avail. I could not find a
> setting for any kind of cache in Excel.
>
> I am using Windows XP SP2 (with all updates) and Office XP (2002, with all
> updates). Another strange thing is that I have several other machines in
my
> office that are set up with the same software that are experiencing this
> issue. However, the helpdesk for the site I am using said they cannot
> replicate the issue and therefore are unable to help me. I called another
> helpdesk and they are also unable to help me. So, help!
>
> UPDATE: I have uninstalled and reinstalled Office 2002 (XP) and it is
still
> doing this.

[Dave Peterson]

You may want to look at this thread. There are a couple of options:

http://groups.google.co.uk/group/mic...1ae81023d06bc3

or

http://snipurl.com/ooc7



tdeniston wrote:
>
> I am accessing a website that generates csv reports for many different
> facilities I service. The csv files all have the same name and, subsequently,
> the same URL. There is some kind of backend script that generates these files
> and opens them in Excel for me automatically when I click the appropriate
> link.
>
> The first time I click the link, it works fine. The second time, I click the
> link that is associated with a different facility, but the data for the first
> facility still shows up in the csv Excel file. I have played with IE's cache,
> cookies, history, and advanced settings to no avail. I could not find a
> setting for any kind of cache in Excel.
>
> I am using Windows XP SP2 (with all updates) and Office XP (2002, with all
> updates). Another strange thing is that I have several other machines in my
> office that are set up with the same software that are experiencing this
> issue. However, the helpdesk for the site I am using said they cannot
> replicate the issue and therefore are unable to help me. I called another
> helpdesk and they are also unable to help me. So, help!
>
> UPDATE: I have uninstalled and reinstalled Office 2002 (XP) and it is still
> doing this.

--

Dave Peterson

[tdeniston]

The URL is the same each time, but the data is certainly not the same. The
helpdesk for my company has been working on this issue and they cannot
replicate it. They verified that the URL is the same each time, but a
server-side script generates different data depending on which options are
selected.

"jaf" wrote:

> If the filename and URL are the same then you are always accessing the same
> file.
> Unless the contents of the file change between clicks the file will always
> contain the same data.
>
> John