Operating system is Windows XP with MS Office 2007. We have numerous Excel workbooks with multiple spreadsheets in each. We have many hyperlinks within each spreadsheet that links to many different directories/folders
When we establish the links they work for days, weeks, months, but then for some unknown reason the links change. We have noticed one condition that causes the hyperlinks to change. Following is the original value/address of the hyperlink: O:\dirnam1\dirnam2\dirnam3\dirnam4\dirnam5\filename where O is a mapped network drive that points to a server. The server is a CIFS/SMB filesystem on a Sun StorageTek 5320C NAS running NAS > OS version 4.21 where dirnam is the different directory levels. Following is what the modified hyperlink changes to, but not always: C:\myname\myhomedir\myid \dirnam1\dirnam2\dirnam3\dirnam4\dirnam5\filename Sometimes, it will just change to the c:\ drive Most of the users who use these files say they only open and save the files on the O drive It does not happen all of the time. Thank you for your time. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
