Updating all graph links in a workbook

G

Guest

I have a workbook that holds values for a large number of graphs. The graphs
are in separate workbooks (about 20 of them), with 3-10 graphs per workbook.
When I open the graph files with a macro (after the data source file is
opened) only the graph on the worksheet that is viewable updates. I'm trying
to figure out how to code the Workbooks.Open function so that all worksheets
on the graph files are updated. Here's a snippet of the Workbooks.Open code:

Workbooks.Open Filename:= "GraphFile.xls", UpdateLinks:=3

I don't understand the UpdateLins:=3 parameter. Is there a list of these
parameters somewhere?
 
G

Guest

in the help for workbooks.open

Value Meaning
0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external references
 

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

Top