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