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 - 04 Apr 2006 18:40 GMT
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
> 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,
[quoted text clipped - 17 lines]
> UPDATE: I have uninstalled and reinstalled Office 2002 (XP) and it is still
> doing this.
tdeniston - 08 Apr 2006 21:28 GMT
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.
> 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
Dave Peterson - 04 Apr 2006 18:58 GMT
You may want to look at this thread. There are a couple of options:
http://groups.google.co.uk/group/microsoft.public.excel.programming/browse_frm/t
hread/a1141e8a918a0b33/ef1ae81023d06bc3?lnk=st&q=temporary+internet+group%3A*exc
el*+author%3Aogilvy&rnum=1&hl=en#ef1ae81023d06bc3
or
http://snipurl.com/ooc7
> 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,
[quoted text clipped - 17 lines]
> UPDATE: I have uninstalled and reinstalled Office 2002 (XP) and it is still
> doing this.

Signature
Dave Peterson