WORKBOOK INDEXING

[7of9]

I have a multipage workbook (40 pages) and want to set up an Index page.

I tried hyperlinking, but when I copy it for the following year's use, the
hyperlinks go back to the originating workbook. I've tried looking up
relative hyperlinks but I don't think that will work either.

I am currently using Excel 2003.

Any suggestions?

 

[Pecoflyer]

I have a multipage workbook (40 pages) and want to set up an Inde
page.

I tried hyperlinking, but when I copy it for the following year's use
the
hyperlinks go back to the originating workbook. I've tried lookin
up
relative hyperlinks but I don't think that will work either.

I am currently using Excel 2003.

Any suggestions?

Could you not use the Index provided by XL ( right-click on th
navigation arrows next to the sheets tabs)

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste