Fellow Experts, I need your help.
I'll be migrating the file server from Netware 5 to Widows Server 2003 this week. There are some problems though.
Let's say, that we have OLD_SERVER and its' network share OLD_SERVER:/DATA is mapped as S:.
Then we have for example:
test1.xls contains a hyperlink to the test2.xls.
I'm going to leave drive mappings and relative paths as they are, but I CAN'T change Windows' computer name (they'll have to differ).
However there are some problems with the Excel files. Even if I insert a hyperlink through a mapped S drive, the program changes it automatically to UNC path (cell contains proper value, but the underlaying path leads to "file://\\OLD_SERVER\Some_
I've found an option in the Excel: Tools->Options->Common->ne
lly update links (don't know if it's a proper translation; I don't normally work with English Office suite).
It doesn't work though (same goes for some registry option in HKCU, implemented in Office 97 SR1).
I've found a KB:
"When a source data workbook is linked, the link is established based on the way that the workbook was opened. If the workbook was opened over a mapped drive, the link is created by using a mapped drive. The link remains that way regardless of how the source data workbook is opened in the future. If the source data file is opened by a UNC path, the link does not revert to a mapped drive, even if a matching drive is available. "
It doesn't work that way however (as I mentioned above: the text in the cell is as should be, but underlaying hyperlink is resolved automatically to absolute path).
I'd appreciate any help.