Update: I found some info about the OnTime function, and I built a macro which seems to work right now.. It refreshes the data every 5 minutes.
But it still doesn't work when I export the worksheet as a web page.. that's what I'm missing. Whenever I export it, the worksheet is completely static, it doesn't update the data even if i refresh the page in the browser.
i hope you understood my situation..
thanks
hello guys,
I have an Excel 2007 worksheet in which some cells get external data from a website every 15 minutes. Therefore, every 15 minutes the worksheet is updated, by refreshing the data and recalculating the formulas. I did this with the data function, and setting the connections properties to update every 15 minutes.
I would like to export/publish this worksheet in HTML format, as a simple website. I tried the normal "save as" etc but it doesn't seem to refresh the data like I want to.
Is there a way to make this happen?
thanks in advance
Andrea
Bookmarks