Updating all graph links in a workbook
 

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?

Updating all graph links in a workbook
 

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

--
Regards,
Tom Ogilvy


"Tele-Wiz" wrote:

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?