View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bob_smithley@yahoo.com is offline
external usenet poster
 
Posts: 3
Default hyperlink problems with multiple sheet spreadsheet on Intranet

Hi,

I have an Excel 2003 file.

It has a "menu" sheet which contains hyperlinks to other sheets. The
hyperlink is the "place in this document" kind - a hyperlink to a
different sheet in the same workbook.

Locally everything works fine.

I am serving the file on an Intranet (IIS 5.0). When the user calls up
the spreadsheet (either served via http:// or file://), when they click
on a hyperlink in the menu page, Excel (or IE) tries to reload the
whole document, instead of simply jumping to the relevant sheet.

I have tried setting a Base Hyperlink, but same behaviour.

The message in the browser, when they click on a hyperlink, is "This
document has been modified. Do you want to save changes?"

How to I get around this?