I have been approached by our stats man who has a very large workbook to publish on the intranet. Due to its size and the number of sheets it has (about 10) he has set up links on the sheets from a front index sheet using hyperlinks to named cells on the other sheets. If I then print this to Adobe Distiller the links are lost. Can anyone suggest:

1) What I am doing wrong
2) Another way to keep the links/create links inside the book without losing them in Distiller

PS I am not allowed to publish the Excel sheet as it stands, under pain of emasculation