+ Reply to Thread
Results 1 to 2 of 2

Dynamic Links

  1. #1
    Registered User
    Join Date
    02-28-2022
    Location
    Mendenhall, MS, USA
    MS-Off Ver
    Professional Plus
    Posts
    1

    Dynamic Links

    I've a Master Template which has links to another Workbook. I must periodically download (from a website) new (updated) versions of the Workbook with the SAME name, otherwise I would have to continually update the Master cell references. When I download a new version of the Workbook, it gets renamed since that name already exists in my Downloads folder (expected). If I delete (or move) existing Workbook BEFORE downloading new version, then I break the links in the Master and it gives errors for each cell referencing the Workbook (expected). BUT, after downloading updated version of Workbook (with same referenced name), cell references continue to show error, even though I have "refreshed" date.

    Surely I'm overlooking some simple solution to what would seem a common problem. Any advice???. Many thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Dynamic Links

    Hi and welcome to the forum,

    I've just answered almost exactly the same question.

    Just use

    Data...Edit Links...Change Source and select the new workbook name.

    Then if you want delete the old workbook and rename the new one which will presumably have a (1) appended to the name.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Creating Dynamic Links
    By jpl69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2019, 09:38 PM
  2. Dynamic Edit Links
    By Rui Farinha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2016, 02:18 PM
  3. Macro for dynamic links?
    By ExcelNUBs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2012, 10:01 AM
  4. Dynamic Links
    By baribill in forum Excel General
    Replies: 2
    Last Post: 10-06-2007, 04:14 AM
  5. Dynamic Links??
    By apesies21 in forum Excel General
    Replies: 2
    Last Post: 01-25-2007, 02:07 PM
  6. Dynamic links within workbook
    By BjornB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-09-2006, 07:54 AM
  7. Dynamic Links Excel 2003
    By ARW in forum Excel General
    Replies: 1
    Last Post: 01-03-2006, 01:55 PM

Tags for this Thread

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