Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Updates | Excel Discussion (Misc queries) | |||
Automatic updates | Excel Discussion (Misc queries) | |||
Automatic Array updates | Excel Discussion (Misc queries) | |||
Sharing - Automatic Updates | Excel Discussion (Misc queries) | |||
AUTOMATIC UPDATES | Excel Worksheet Functions |