Its the 3rd party report generator that I run my excel sheet through that changes the "names" on the tab that screws up my links.

I do know what naming convention the report writers uses and how it is going to change the name of the tab. I just can't think of a good way to solve my problem. I am leaning towards writing a simple Marco, to edit replace my changed link names to the new names after the report is generated.

But outside of that, I don't have a clue.