How solve hyperlink problem in excel

By lngupta.ivrcl ·
I hyperlinked the TIFF Files in Excel. I copied the excel file along with hyperlinked TIFF files to another location. When I opened the excel file and clicked on the hyperlink the file did not open and displayed a dialog box "Cannot Open the Specified File".

Please help me to resolve the problem.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

It sounds like the links are static...

by Darryl~ Moderator In reply to How solve hyperlink probl ...

they should be set as relative....for example, they should not be c:\documents and settings\username\desktop\filename.tif

You should put the Excel file & the TIFF files in a folder and set the links like this... \foldername\filename.tif

That way the Excel sheet becomes portable & the links move with it.

Related Discussions

Related Forums