+ Reply to Thread
Results 1 to 10 of 10

workbook only updates links when i open it

Hybrid View

  1. #1
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: workbook only updates links when i open it

    Hmm? That's odd, what type of connection do you use?

    It may be that since, xls doesn't use Open XML for file structure, it behaved differently. But then, I'm only familiar with Excel 2010 and up.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  2. #2
    Forum Contributor
    Join Date
    02-06-2013
    Location
    toronto
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: workbook only updates links when i open it

    yah, it was driving me crazy...i jsut wanted to know why....eventually i convinced my team that the logistics was nonsensical and to just make the "capital" file link directly to the "repo template" file...now I just go to "data" --> "edit links" --> updates values and so it's all good now.
    Last edited by AliGW; 08-17-2019 at 01:34 AM. Reason: Please don't quote unnecessarily!

+ 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. [SOLVED] links to open closed workbook
    By kriminaal in forum Excel General
    Replies: 1
    Last Post: 07-09-2016, 09:52 AM
  2. workbook.refreshall leaving links open
    By yarnseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 02:19 PM
  3. [SOLVED] Workbook links causing linked workbook to open, but remain hidden
    By Rob T in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2014, 06:24 AM
  4. Excel links only updates when source workbook is open
    By excellearner121 in forum Excel General
    Replies: 1
    Last Post: 03-24-2014, 02:59 AM
  5. Prevent updating links on workbook open in VBA
    By hvkelley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2013, 07:34 AM
  6. Don't update links on workbook open
    By dylanemcgregor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2009, 07:32 PM
  7. [SOLVED] inter workbook links do not update even when both are open ???
    By Lawrenph in forum Excel General
    Replies: 3
    Last Post: 06-03-2005, 10:05 AM

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