Automatic Updates
 

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

Automatic Updates
 

You can schedule a windows task to open a workbook. When the workbook opens,
you can insert code to auto refresh and save.

An easier approach is to always have a master workbook open and at specified
times (using a "wait" or similar function), have the workbook update and save
a copy of itself.

Either works, but it is easier to code the latter and I have found it is
more reliable.

Regards,
Bill Pfister



"TheRook" wrote:

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