Question Locked

How solve hyperlink problem in excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by darryl~

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.

This discussion is closed to new replies.