Results 1 to 2 of 2
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Spontaneous File Link Changes

    This is a new one on me. My users are complaining about formulas linking to external workbooks changing spontaneously. That is, an external link changing the file path to a new nonexistent location. My googling took me to and ultimately to The problem appears (if I'm reading the Knowledge Base article correctly) when the users access the files through a mixture of UNC paths and mapped drives. Arrgh! Well of course this is going to happen in our scenario, since we have multiple users accessing these files and not all users are set up the same. Questions? Have you seen this problem? Does the hotfix described here actually solve the problem?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Warrington, Cheshire
    Thanked 0 Times in 0 Posts
    We are experiencing this problem with virtualised servers and excel 2010 files.
    Link formulas cells return #REF! and on other occassions return maybe a 0 instead.
    I cannot repeat the error on demand but using the replace option of replacing "=" with "=" refreshes the link and hopefully returns the correct value.
    In financial terms this is priority 1 serious with incorrect sums already having been reported to powers that be.

    Need a fix asap so it's all hands on deck till it's fixed.

Posting Permissions

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