Live Spreadsheet on Intranet

[Cullen]

I want to display a spreadsheet on our intranet. There is not need to edit the sheet only to view it live or close to live (update every x minutes).

I wrote a macro to save the sheet as a xml file every so often but I am having trouble getting that to refresh in browsers.

Does anyone have any experience/recommendation for this?

Thank you,
Cullen

 

[tweedle]

I would guess the problem is not with Excel/XML, but that the browser needs a javascript (or equivalent) to refresh/reload at some frequency...

 

[Cullen]

I have downloaded scripts before that do this but the my problem is that even when you physically click refresh no updates occur. You have to close the file and re-open to view the changes.

I'm sure there is some setting that I am not aware of on the browser level but I cant figure it out.