<< Click here to Goto HomePage


Tuesday, April 03, 2007

Excel Tip :: How to insert Hyperlinks in Excel

If you work with hyperlinks in Excel, you have to look out for a couple of settings so that your hyperlinks are not changed from absolute to relative hyperlinks when saving the file.

To avoid the "relativization" of your links navigate to Tools > Options > General > Web Options > Files and uncheck the option "Update links on save".

In addition you should always use the so called UNC path to files or folders rather by direct pasting the path in the hyperlink dialog box then by choosing a file from within that Excel dialog.

More information on Excel behavior concerning hyperlinks can be found in the Microsoft Knowledge Base.