Hello All,
This is my first post, so here goes.

I have simple links between tabs in my spreadsheet but the reporting software I use is called YSL, and it changes the name of tabs when it is run.

So if any simple links I make (ex. ='t-prop'!e1) changes to ='prop'!e1 and I get an error before the report even finishes running.

Ideally I don't want to add the tabs after the report, due to the volume of reports and the only solution I can come up with (using my limited excel knowledge) is creating a simple Macro to edit replace a value in these simple links after the report is ran.

I appreciate any ideas.

Thanks.