Links in same spreadsheet problem

D

dyun1dyun1

I have a multi-tab spreadsheet with simple links referencing differen
cells.

The problem I am having is that it the spreadsheet goes through
report generator and it changes the tab names, creating broken links.

Any ideas in solving this problem
 
G

Gord Dibben

Excel should change the tab names in the linking formulas.

Sheet1!A1 in Sheet2 should change to changed!A1 if Sheet1 gets renamed as
changed.

I have no prblems with Excel 2003 keeping track of sheet name changes.

If you are speaking of Hyperlinks then the name change will screw those up.


Gord Dibben MS Excel MVP
 
D

dyun1dyun1

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.
 
Top