Have you considered using MS query instead of links. For indiviual
cells links are great, however for whole tables/columns I find query
works a lot better and can be customised more (refresh by minute/on
startup, not to metion autofilling adjacent formulas).

Giff