No announcement yet.

excel hyperlink nightmare

  • Filter
  • Time
  • Show
Clear All
new posts

  • excel hyperlink nightmare

    ok we have alot of excel files that were created on a network server. that server is now long gone an the files were moved to a new service with the same directory structure. Now all excel hyperlinks are borken. they are all using realitive hyper links. and even though the files are ware they should be they dont work. Their is no hyperlink base set and setting one doesn't seem to do anything. if i manully edit it changes back to realive when i save and reopen. The "hyperlink base" that its using looks like it is whatever directory the file is saved in. their are no macros or anything like that in the excel file. any idea how to convert them all to absolute hyperlinks.
    MCSE 2000\2003, A+