LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Wrong Hyperlink location after sorting

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loosing correct hyperlnk location after sorting spreadsheet data LostnSpace Excel Discussion (Misc queries) 2 February 2nd 06 10:15 PM
Stock Location Sorting Problem mark1caroline Excel Discussion (Misc queries) 3 July 13th 05 03:53 PM
hyperlink an excel cell to a specific location wthin application f dirtboy New Users to Excel 1 January 17th 05 08:07 PM
hyperlink an excel cell to a specific location wthin application f dirtboy Excel Discussion (Misc queries) 0 January 17th 05 08:03 PM
Removing hyperlink Frank Marousek Excel Discussion (Misc queries) 3 January 12th 05 09:53 PM


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"