+ Reply to Thread
Results 1 to 3 of 3

Keep getting #REF! until I open the linked workbook

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    new york city, new york
    MS-Off Ver
    Excel 2011
    Posts
    20

    Keep getting #REF! until I open the linked workbook

    Hi,

    So I have linked a workbook 1 to workbook 2. The problem is that the second half of the worksheet shows up cells that say #REF! and the other half shows up normally. The #REF! goes away once I open up the second workbook. All the cells are linked to workbook 2 so I don't know why its showing #REF! for only half the cells.

    I have attached a picture for reference.

    ref issue.jpg

    Please help!

    Thank You,

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Keep getting #REF! until I open the linked workbook

    Have you tried opening it without updating the links?

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    08-05-2013
    Location
    new york city, new york
    MS-Off Ver
    Excel 2011
    Posts
    20

    Re: Keep getting #REF! until I open the linked workbook

    Yes, still not working

+ 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. my INDIRECT formula only works when the linked workbook is open
    By apiekar42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2013, 06:46 PM
  2. Replies: 1
    Last Post: 03-18-2013, 11:09 PM
  3. Macro to open a closed workbook and select copy cells into an open workbook
    By helloganesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 02:00 PM
  4. Replies: 1
    Last Post: 11-10-2012, 12:13 PM
  5. Save an open workbook, then open template workbook and close the saved workbook
    By ondvirg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2009, 10:20 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1