brettdj
12-05-2005, 04:41 PM
Guys
A question I posted at EE earlier today. I am using Excel 2003, SP 1
I've built a workbook template with indentical input sheets and I'm using hyperlinks to local range names for major sections (Revenue in A100, Capex in A364 and so on)
Capex ='Alt 2. 10|U|T|M - Mid Mine Plan'!$A$364
etc
All is going well until I rename a sheet, and voila, the hyperlink is now invalid. Has anyone seen this before, and more importantly is there anyway around it? Global range names wth hyperlinks work fine with a sheet name change, Excel just remaps like it normally does
Its an internal work example to be published on our intranet so code is out of the question
Cheers
Dave
A question I posted at EE earlier today. I am using Excel 2003, SP 1
I've built a workbook template with indentical input sheets and I'm using hyperlinks to local range names for major sections (Revenue in A100, Capex in A364 and so on)
Capex ='Alt 2. 10|U|T|M - Mid Mine Plan'!$A$364
etc
All is going well until I rename a sheet, and voila, the hyperlink is now invalid. Has anyone seen this before, and more importantly is there anyway around it? Global range names wth hyperlinks work fine with a sheet name change, Excel just remaps like it normally does
Its an internal work example to be published on our intranet so code is out of the question
Cheers
Dave