autoupdating Excel

R

rorytmeadows

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
What exactly excel do when copying worksheets? 5
Excel 2007 printing error: "The number must be between 10 and 400. 3
Increase in the Size of the Excel WorkBook 1
"no more new fonts" - how to avoid this in an excel file 2
Converting Graphs from 2003 to 2007 3
Link error #VALUE 5
Can I paste an EXCEL chart from a word doc into EXCEL and edit it 1

Top