Have a excel file online which auto refreshes data - is this possible?

Hi,

I have a excel file which is connected to a database on a server, when I click data, refresh, I get an updated list.

I then have to email that new list each day to different people.

Is it possible to have the file online, so those people can go to the webpage and download the file, but while that file is online it auto refreshes.

So that the people I send the file to will be able to get the latest version without me having to send it out each time.

I have checked as much as I can and it seems the best way to do this would be save as web page, but my excel only has 'save single file webpage'

Any help would be great.

Thank you.
Chris

Wow, thanks that's great.

I will have to try those in the morning, will post my findings.

Thank you once again for your help.


Chris