Results 1 to 3 of 3

Thread: linking workbook error

  1. #1

    linking workbook error

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I linked one sheet 2 in one workbook to another workbook. When i keep both the workbook open and when i update the source workbook , the new work book is updated as well. But the problem is when i open the new workbook(copied workbook) when the source workbook is closed, the new work book is not getting updated still the source workbook is opened.
    Does any one have any idea?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    If I get this right...

    You have WorkbookA that is linked to WorkbookB
    When you open WorkbookB first, then WorkbookA, updating workbookB's cell shows the change in WorkbookA's cell
    But when you open WorkbookA, then WorkbookB and update WorkbookB, it's not updating WorkbookA

    Is that correct? If so, I can't reproduce it.

    The things I would check are that both workbooks are in Automatic calculation mode (and save them both once you've confirmed it). You can also force links to update by going to Data--> Edit Links --> Update Values. You may also want to check in that dialog that the "Update" is set to "Automatic" not manual.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Sorry . No.
    I have the a COUNTIF function used on one workbook which refers to another workbook, however I get the result #value! unless the other workbook is open - this is even if I chose to update links when I fist open the file.

    Do all workbooks have to be open when using COUNTIF?

    If I open the other workbook after my workbook with the COUNTIFs on has been opened then all #value! errors disappear and the correwct info is shown.

Posting Permissions

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