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