Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open external book before updating links?
I have a workbook that has thousands of links to another workbook
probelm is, they all use "IDIRECT(BLAH)" formula's and are very slow a updating. All the links point at the same external workbook. I want to make an opening macro that will open up the external boo first befire trying to update any links. I tried making calculation manual first and then open the external book but this didnt work. The only way I have suceeded is to have an 3rd book which opens up th external book then the workbook with the links. Can anyone think of a better way -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating external links | Links and Linking in Excel | |||
how do I improve performance when updating external links? | Excel Discussion (Misc queries) | |||
Problem with updating external links | Excel Discussion (Misc queries) | |||
Updating External Links | Excel Discussion (Misc queries) | |||
External Links not updating | Excel Discussion (Misc queries) |