View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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