Not exactly an excel question but thought you maybe able to help.

I currently have an excel speadsheet that has a link to SQL server. I am
the only person that has access to SQL. SQL updates the tables at 1 am
everyday. To update the spreadsheet I have to open the file, refresh and
then save for other people to be able to see the changes.

What I am wanting to do is to set some sort of task that will automatically
open the spreadsheet at 2am, refresh it and save it.

The reason I am wanting to do this is so that when I am holiday the
spreadsheet is always upto date. (Plus it saves me doing it)

Is this possible??

The Rook