ORDER IN WHICH LINKS UPDATE
I don't think there is any advertised order or way to control that order.
As a possible (untested) workaround:
You could set links not to be updated automatically, turn calculation to
manual, then use code to go through your links in order and update them
individually.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
Is there a way to rearrange the order in which "links" to other
workbooks appear. Example I have a workbook that links to 52 other
workbooks. It starts in the correct order but then begins to go out of
order. This is a sales calendar that begins with Jan week 1 and so on.
January does fine but starting in February it starts with week 2 then 3
then 4 then 1. I have tried opening the links but they do not appear
moveable there. Thanks
|