I'd drop the insert|hyperlink type of hyperlinks and use a cell in the same row
with the =hyperlink() function:

If Dsc0001.jpg was in A1, I could use:

=hyperlink("file:////c:\parkerfuneralhome\" & a1)

or something like this formula.

Lawulm wrote:

Im using Excel to do an index of funeral home records. Copy of each page
was taken with a digital camera with a number for each such as DSC0001,
DSC0002, or DSC0003 etc. I enter the name, then the digital number in a
difference column. I hyperlink the spreadsheet to the name on the hard
drive. By waning over the spreadsheet name I will see the correct link as
file:///C:\parkerfuneralhome\dsc0001.jpg. I then sort the file by Last name
for viewing. This works fine for the first 5000 or so records, but when I
added records up to 7000 the sort will change the file name to
file:///C:\Documents and Setting\HP_Administrator\Application
Data\Microsoft\Exec\DSC0001.JPG I cant view the JPG file due to the wrong
file location. The default file location is C:\parkerfuneralhome. Am I
doing something wrong or is there a bug in Excel? The computer is a HP with
2 gigs of memory and 3.2 gig processor.

Thanks for the help

--

Dave Peterson