+ Reply to Thread
Results 1 to 9 of 9

Broken hyperlinks to files

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2003
    Posts
    11

    Broken hyperlinks to files

    Well, did some searching, found some posts with similar issues but could not implement any solutions. I have a file (sits on a server and is accessed by two computers) that has links to files (the links are so that you can find the file easily, not data links) that are on the same server. All of a sudden, the links changed and cannot be accessed. Both PC's are Windows 7 with Excel 2013. There is no "sharing", the file is just opened by one user or another (one at a time).

    There links were originally of the format: \\PSSERVER\PSI_Documents\QUOTES\Customer name\ABC-123.doc

    They have now changed to something like: C:\Users\jim\AppData\Roaming\Microsoft\Excel\Customer name\ABC-123.doc ("jim" is the other user).

    In doing my searching, it sounds like I should be able to get into "edit links" under the Data tab but that option is grayed out.

    Can somebody please help?

    Thanks!
    Biederboat
    Last edited by biederboat; 12-09-2014 at 07:51 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Broken hyperlinks to files

    The new link looks like it is pointing you a local hard drive, not the server C:\Users\ji...............
    Have you tried to re-link them manually and then save them again?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-22-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Broken hyperlinks to files

    Quote Originally Posted by FDibbins View Post
    The new link looks like it is pointing you a local hard drive, not the server C:\Users\ji...............
    Have you tried to re-link them manually and then save them again?
    I didn't try re-linking them but I did add another link to a new file which is still working. I am not sure the other user has opened up the file though (which is whose local drive they are point to). I'll try that when I get a chance.

    BB

  4. #4
    Registered User
    Join Date
    04-22-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Broken hyperlinks to files

    So, yes, if I manually edit the link it works fine; at least after I edited, saved and then opened the file. I suspect there must have been some kind of "event" that triggered the re-linking to the currently "incorrect" links and that's what I'm trying to figure out. There's way too many files to manually edit all the links though; is there any way to "dial back the clock"?

    Thanks,
    Mark

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Broken hyperlinks to files

    is there any way to "dial back the clock"?
    Have you spoken to your IT department/person yet?

  6. #6
    Registered User
    Join Date
    04-22-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Broken hyperlinks to files

    Quote Originally Posted by FDibbins View Post
    Have you spoken to your IT department/person yet?
    Sure, I talk to myself all the time! Sorry, we're a whopping 10-person company and outsource our IT. I did submit a request to see how old of a back-up copy I could retrieve out of the mist in the clouds. That might work as a band-aid fix as I could possibly add the missing data if the links in the older file still work but I'd still like to know if there's a way to "fix" the links.

    BB

  7. #7
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365
    Posts
    963

    Re: Broken hyperlinks to files

    Find/Replace- Look in Formulas. Old path. . . Enter the new path. . .seems like it might work.

    Pete

  8. #8
    Registered User
    Join Date
    04-22-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Broken hyperlinks to files

    Quote Originally Posted by PeteABC123 View Post
    Find/Replace- Look in Formulas. Old path. . . Enter the new path. . .seems like it might work.

    Pete
    Thanks, tried it but that doesn't seem to work. This is a hyperlink, not a link that's part of a formula (like a lookup); it's a number entry in the cell and then you right click>Hyperlink>Existing File or webpage>point to the file and hit "okay". You end up with a hyperlink on the cell that brings up the linked file so that you can easily retrieve it.

    BB

  9. #9
    Registered User
    Join Date
    04-22-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Broken hyperlinks to files

    So I got the oldest copy I could from our IT service, which was about a week old, and the links all worked so it was relatively easy to add the missing data. Still would like some help on how to eliminate this in the future. The only thing I can think of is that we did an office repair on the other computer since the spell check was working very erratically. We did the after the data from which the backed-up copy was received.

    BB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Checking for broken hyperlinks
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 06-22-2018, 02:46 PM
  2. Worksheets with broken or no hyperlinks
    By Geoffreym in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-12-2014, 06:20 AM
  3. Find broken hyperlinks and highlight them
    By SIM.SIM in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2013, 05:39 PM
  4. Excel 2007 : Hide Broken Hyperlinks
    By mrbougles in forum Excel General
    Replies: 0
    Last Post: 03-11-2011, 06:57 AM
  5. Broken hyperlinks
    By Nigel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-16-2008, 05:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.07124 seconds
  • Memory Usage 9,084KB
  • Queries Executed 15 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (4)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (9)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (9)postbit_legacy
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1