ORDER IN WHICH LINKS UPDATE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KRYSTALATLF07@EARTHLINK.NET - 24 Jan 2006 16:33 GMT

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

Reply to this Message

Tom Ogilvy - 24 Jan 2006 18:26 GMT

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.

Signature

Regards,
Tom Ogilvy

> 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
[quoted text clipped - 3 lines]
> then 4 then 1. I have tried opening the links but they do not appear
> moveable there. Thanks

Reply to this Message