+ Reply to Thread
Results 1 to 2 of 2

Update links between workbooks

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    10

    Update links between workbooks

    having an issue with updating links between workbooks, wondering if anyone has come across this and can help. Workbook 1 has all data, and Workbook 2 takes all the important data I need from workbook 1 by using a sumif function. My issue is that If I just open up workbook 2, all the data isn't there, it just has #value!. It's not till I open Workbook 1 while still having workbook 2 open that the data pops in there. So to sum up, both workbooks have to be open. my excel options are set to automatically update links, so I am not sure what is wrong. Any help is appreciated!

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Update links between workbooks

    SUMIF will never work on a closed workbook.

    You could use SUMPRODUCT instead, which will work on a closed workbook.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. How to update master workbook with links to other workbooks
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-09-2012, 06:16 AM
  2. Automatically update links to other workbooks
    By krabople in forum Excel General
    Replies: 0
    Last Post: 10-09-2006, 08:31 AM
  3. Links auto update on some workbooks but not others
    By Tasza in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2005, 09:05 PM
  4. [SOLVED] Update links to other workbooks while running macro
    By kaininito@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2005, 02:05 AM
  5. [SOLVED] Can you update links between workbooks without them both open?
    By Nicolle K. in forum Excel General
    Replies: 1
    Last Post: 01-07-2005, 04: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