Avoiding Excel Link Hell

[XLVBAUser]

Hello

In the process of trying to update a whole bundle of corporate spreadsheets that are linked all over the computer network.

Worse still is this organisation is moving premises in a couple of months and drives/machines names are likely to change and break a whole lot of links.

Any practical suggestions on how to make managing and updating these links easier?

Cheers

 

[Ron Coderre]

Any practical suggestions on how to make managing and updating these links easier?

This isn't what you want to hear and this isn't the first time I've given this advice:
Do not link workbooks...ever. The resulting structures of linked workbooks are fragile, at best, and fail catastrophically at the worst possible time.

I've inherited many of those failures over the years. The only dependable remedy is to rebuild the structure using almost any other alternative: Data Consolidations, Pivot Tables, Queries via MSQuery, etc.

 

[XLVBAUser]

Thanks.

Part of what I am trying to do it minimise/eliminate links.