It sounds like you need to re-assess whether linked cell formulas is
the best way to share information between locations.

--

"Karl Burrows" wrote in message .. .
Hi!

I have built a pretty big library of Excel workbooks that are all related.
They all follow a pretty similar format and are all linked back to one
primary workbook that drives the primary data used in all the other
workbooks (builders, projects, start dates, current reporting date, etc.).

The problem I have is no one seems to understand that you have to have all
the workbooks open to rename a tab (if the project were to end and a new one
was created in it's place) and we then get errors all over the place and I
have to spend a bunch of time rebuilding all the links. It also takes
forever to open all of these workbooks at one time just to rename a tab and
keep the links active (probably close to 30MB total)

Is there a way to programmatically create links based on the worksheet
number rather than the tab name to keep the links regardless of what I name
them? That would save me a ton of time and a lot of headaches.