If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
WORKBOOK INDEXING
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? |
#2
|
|||
|
|||
WORKBOOK INDEXING
7of9;233580 Wrote: 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? Could you not use the Index provided by XL ( right-click on the navigation arrows next to the sheets tabs) ? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65206 |
Thread Tools | |
Display Modes | |
|
|