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?
|