Home |
Search |
Today's Posts |
#1
|
|||
|
|||
autoupdating Excel
I have a large Excel workbook that contains about 200 links to other
Excel spreadsheets. I then have 200 Excel graphs (saved as workbooks with only a graph page) that are based off of the large Excel workbook. As of right now, In order to have the graphs updated, you have to open the large workbook and update when prompted, then open the graph files and update when prompted. With 200 links, this can take a long time. Is there any way to schedule updates of these links within the file using script or scheduler? I'm not always going to be here to open the file and when an update is needed for the graph I don't even want to open the large workbook. My IT team here is stumped. Everything is on servers. |
#2
|
|||
|
|||
goto google and enter
autoupdate excel and click the first Macrosoft link "rorytmeadows" wrote: I have a large Excel workbook that contains about 200 links to other Excel spreadsheets. I then have 200 Excel graphs (saved as workbooks with only a graph page) that are based off of the large Excel workbook. As of right now, In order to have the graphs updated, you have to open the large workbook and update when prompted, then open the graph files and update when prompted. With 200 links, this can take a long time. Is there any way to schedule updates of these links within the file using script or scheduler? I'm not always going to be here to open the file and when an update is needed for the graph I don't even want to open the large workbook. My IT team here is stumped. Everything is on servers. |
#3
|
|||
|
|||
My colleague wants you to create a BAT file then use a scheduler to run the
file overnight. And he thinks Macs are the best computer... "rorytmeadows" wrote: I have a large Excel workbook that contains about 200 links to other Excel spreadsheets. I then have 200 Excel graphs (saved as workbooks with only a graph page) that are based off of the large Excel workbook. As of right now, In order to have the graphs updated, you have to open the large workbook and update when prompted, then open the graph files and update when prompted. With 200 links, this can take a long time. Is there any way to schedule updates of these links within the file using script or scheduler? I'm not always going to be here to open the file and when an update is needed for the graph I don't even want to open the large workbook. My IT team here is stumped. Everything is on servers. |
#4
|
|||
|
|||
the VBA script link on msdn?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |