Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loosing correct hyperlnk location after sorting spreadsheet data | Excel Discussion (Misc queries) | |||
Stock Location Sorting Problem | Excel Discussion (Misc queries) | |||
hyperlink an excel cell to a specific location wthin application f | New Users to Excel | |||
hyperlink an excel cell to a specific location wthin application f | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |