refresh

marclena · March 24th, 2004, 08:58 AM

Hi,
I've got a problem
I have an asp page with a button.
When I click the button it calls a javascript function which use a window open to open an excel spreadsheet.
This works fine, but if I change the spreadsheet and I click the button again it doesn't reflect the last changes.
Why is that?

Thanks in advance

joefawcett · March 24th, 2004, 09:05 AM

Can we see a minimal example of the code you're using?

--

Joe

marclena · March 24th, 2004, 09:11 AM

<html>
<head>
<javascript language="javascript">
function nav()
{
var a=window.open
("http://localhost/dashboard/dashreport/current/testmarc0704.xls")
}
</script>
</head>
<body>
<input type="button onclick="nav()">
</body>
</html>

joefawcett · March 24th, 2004, 09:54 AM

It's probably because your browser has cached the page. You can try two things. Go to Tools|Internet Options|General Tab - middle section - settings. Change to 'every time you visit page'.
Or add a query string to the url:

Code:

function nav()
{
var sBaseUrl = "http://localhost/dashboard/dashreport/current/testmarc0704.xls";
var dt = new Date();
var iRandomInt = dt.valueOf();
var sFullUrl = sBaseUrl + "?q=" + iRandomInt;
var a=window.open(sFullUrl);

}

--

Joe

marclena · March 24th, 2004, 10:29 AM

It works.
Thanks a lot for your help.