Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a coworker who has created a spreadsheet with links to an external website. They links keep breaking. She opens the file, makes an edit (not to a link), re-saves the file, and closes it. The next time she opens the file, the links look like links (blue, underlined text), but they aren't links anymore. She has to recreate the links virtually every time she opens the file.

    Any suggestions?

    I asked if she is changing the location of the worksheet - no


    Thanks.

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Eindhoven, Noord-Brabant, The Netherlands
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If this only happens to your co-worker, than this might help:

    In Excel, click Tools, Options, General, Web Options, Files, uncheck "Update links on save".

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Not sure if this is happening to anyone else. She is the only one who works on this file. I will, however, have her check the settings you mentioned. Thanks for the suggestion. I'll let you know if that fixes it.

Posting Permissions

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