Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
links within workbook are not updating | Excel Discussion (Misc queries) | |||
Bug: Move or Copy sheet graph links not updating! | Excel Discussion (Misc queries) | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
Links not updating in shared workbook | Excel Worksheet Functions | |||
Updating links to new workbook with same format | Links and Linking in Excel |