+ Reply to Thread
Results 1 to 2 of 2

Opening Linked Files Breaks the Links Between Them

  1. #1
    Registered User
    Join Date
    Memphis, Tennesee
    MS-Off Ver
    Office 2013

    Opening Linked Files Breaks the Links Between Them

    Hi all,

    I have a spreadsheet that retrieves about 150 totals from about 50 different spreadsheets. The original workbook works fine when it's open and I can edit it, and the linked workbooks work fine when they're open as well.

    But the moment I open the main workbook AND open any linked workbook right after it, the linked cells go from:
    which breaks all the links to the opened sheet. I don't lose all 150 links, just the ones that linked to the opened workbook.

    Closing the linked workbook doesn't help, the File Path returns but links stay broken because the Worksheetname remains as #REF.

    Does someone understand what's going on here? Why would it change the name of the worksheet inside the cell to #REF?

    I should mentioned that I moved all the files to a shared drive before this happened. I used a macro to replace all the links with the correct links. I know the links are correct after I use the macro because I can change any of the linked workbooks and it will update in the main workbook. But the moment I open the main workbook and any linked workbook together, I lose that set of links.

    Anyone seen this before? I appreciate any help or direction.

  2. #2
    Registered User
    Join Date
    Atlanta, GA
    MS-Off Ver
    MS Excel 2007

    Re: Opening Linked Files Breaks the Links Between Them

    I am experiencing the same issue since moving all files to a cloud server "Egnyte". Have you found a solution to the problem?

+ 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. Mail merge from Excel to Word, moving the files breaks links?
    By BoldCreature in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2014, 10:46 AM
  2. Replies: 1
    Last Post: 02-02-2014, 08:04 PM
  3. How to copy linked Excel and Word files and retain links
    By ashleynpeters1 in forum Excel General
    Replies: 7
    Last Post: 05-30-2013, 08:27 PM
  4. Replies: 0
    Last Post: 10-05-2012, 07:22 PM
  5. Replies: 2
    Last Post: 02-09-2011, 10:45 AM
  6. Replies: 0
    Last Post: 10-07-2010, 02:35 AM
  7. Replies: 0
    Last Post: 11-15-2007, 03:40 AM
  8. [SOLVED] opening excel files with links to other data sources
    By Saul in forum Excel General
    Replies: 1
    Last Post: 05-22-2005, 08:06 PM

Tags for this Thread


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1