 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Hyperlinks Broken after saving.
We have an Excel 2003 spreadsheet with one column that has a series of hyperlinks to a network drive that is on a different server than the one the spreadsheet is on. After creating the hyperlinks. we are able to use them and all is well. As soon as we save the document the links no longer work eventhough we haven't closed the document. If we create hyperlinks to a folder on the same server as the spreadsheet we can save the document and it all works fine. Any ideas? Thanks Steve What do the hyperlinked references look like? Can you post an example? Do they refer to mapped drives (z:\Folder\myfile.xls) or did you use the UNC (\\server\Folder\myfile.xls) so they work on any networked PC? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > We have an Excel 2003 spreadsheet with one column that has a series of > hyperlinks to a network drive that is on a different server than the one [quoted text clipped - 9 lines] > > Steve We are creating the hyperlink using a mapped drive but the resulting Hyperlink creates a UNC \\DellNas\Utility\Database The Hyperlinks are to folders not a specific file. > What do the hyperlinked references look like? > Can you post an example? [quoted text clipped - 23 lines] >> >> Steve Tools, Options, General, Web Options, Files, UNcheck "Update links on save" > We are creating the hyperlink using a mapped drive but the resulting > Hyperlink creates a UNC \\DellNas\Utility\Database The Hyperlinks are to [quoted text clipped - 28 lines] >>> >>>Steve A few people have said that this has resolved the problem for them: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) I like to use the =hyperlink() worksheet function. It has never failed me this way: =hyperlink("file:////yourpathtothe/something.xxx","Click me") > We have an Excel 2003 spreadsheet with one column that has a series of > hyperlinks to a network drive that is on a different server than the one the [quoted text clipped - 9 lines] > > Steve  SignatureDave Peterson Thanks for the responses! This was the suggestion that fixed it and doesn't require a change on each of the desktops. >A few people have said that this has resolved the problem for them: > [quoted text clipped - 23 lines] >> >> Steve Yep, thanks Bob! your instructions fixed it. The other guys I work with don't have this problem with "update links on save" being checked, so it must be the way my PC is configured to connect to the network drive. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.