+ Reply to Thread
Results 1 to 2 of 2

Excel may not update external links when opening a WB

  1. #1
    Registered User
    Join Date
    12-30-2017
    Location
    Luxembourg
    MS-Off Ver
    2016
    Posts
    33

    Excel may not update external links when opening a WB

    Hi,
    When I open, by macro, WB1, despite the fact that the WB to which links of WB1 are pointing is open itself, Excel pretends not to be able to update the links.
    When I choose to modify the links, and I select the linked WB, everything is ok.
    How may I prevent that problem?
    Kind regards
    AmicusA

  2. #2
    Registered User
    Join Date
    12-30-2017
    Location
    Luxembourg
    MS-Off Ver
    2016
    Posts
    33

    Re: Excel may not update external links when opening a WB

    Ok,
    I think having found the solution: I haved saved the ".xls" destination file as ".xlsm" and since it works!
    Regards

+ 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] Update external links without opening workbook
    By elliotencore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2013, 09:45 AM
  2. NOT update External Links when opening a word document via excel macro
    By debbie2852 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2013, 04:49 PM
  3. [SOLVED] Update External Links w-i-t-h-o-u-t VB
    By jasonineverett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2012, 12:13 PM
  4. Getting excel to update links without opening the file..
    By JONNY981 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2009, 04:51 AM
  5. Replies: 0
    Last Post: 11-15-2007, 03:40 AM
  6. [SOLVED] [SOLVED] Update external links prompt upon opening
    By Nate in forum Excel General
    Replies: 1
    Last Post: 02-24-2006, 07:40 PM
  7. how do I activate links without opening external workbooks?
    By teh_chucksta in forum Excel General
    Replies: 0
    Last Post: 08-29-2005, 07:05 PM
  8. [SOLVED] Excel 2003 prompt to update external data links
    By Joel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2005, 03:00 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