+ Reply to Thread
Results 1 to 7 of 7

Links to other workbooks

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    3

    Question Links to other workbooks

    Hi there,

    I have a couple spreadsheets that have formulas linked to other workbooks.

    Upon opening these workbooks I seem to receive a #REF! error on the formulas with these links. I.e VLOOKUP($B110,#REF!,MATCH($P$2,#REF!,0),0) - #REF! being the link to the other spreadsheet....

    I.e one workbooks shows budget number and another shows actual's - when trying to bring the actual's into the budget spreadsheet I receive the #REF! error.

    Any ideas to prevent this happening and having to revise the formulas each time I open the workbooks?

    B

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,863

    Re: Links to other workbooks

    its better at attach sample file with required result enter manually. See yellow banner on top of the screen.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    07-01-2020
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Links to other workbooks

    A separate spread sheet wont give too much more information than what is above as I have to delete confidential info.
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,676

    Re: Links to other workbooks

    You should upload lookup WB along to see why REF#
    Just guess that the sheet name in lookup WB has been changed

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Links to other workbooks

    Could you please give an example formula WITHOUT the error?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Registered User
    Join Date
    07-01-2020
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Links to other workbooks

    No there has been no changes to the other workbook, the spreadsheet just seems to loose the link between the two? Strange..

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Links to other workbooks

    Please see post #5.

+ 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. Recursive links; workbooks that refer to workbooks that refer to workbooks..
    By JimmyWilliams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2018, 10:52 PM
  2. links between workbooks
    By bugdout in forum Excel General
    Replies: 6
    Last Post: 06-18-2016, 02:00 PM
  3. Update workbooks links witout opening the workbooks
    By no1freeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2015, 03:54 PM
  4. How do you get rid of links to other workbooks?
    By gshock in forum Excel General
    Replies: 3
    Last Post: 09-03-2008, 05:48 PM
  5. Links to other workbooks??
    By mattcross55 in forum Excel General
    Replies: 3
    Last Post: 05-09-2008, 10:11 AM
  6. Links between workbooks
    By Eddie in forum Excel General
    Replies: 0
    Last Post: 04-18-2005, 11:06 AM
  7. Links to other workbooks
    By Darrell Wesley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 05:06 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