+ Reply to Thread
Results 1 to 2 of 2

How can my pasted links keep being updated when I save a new version of source file?

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    45

    How can my pasted links keep being updated when I save a new version of source file?

    Hi all

    I'm trying to copy and paste a graph from one file to another. The idea being that when I change the graph in the source file, it automatically updates in the second file. This works fine if I paste special - link but I have a problem with the source file. Every time I make a change to the source file, I save it as a new document (so have lots of old files).

    My question is, is it possible for the graph in the second file to constantly be linked to my 'latest' source file or will I have to copy and paste it every time?

    Hope that makes sense!

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: How can my pasted links keep being updated when I save a new version of source file?

    Why not just always have the latest version held with the same name "MyApp_Current.xls" or something like that and then save the previous versions under different names eg when a new version is required, save the current version as MyApp_2015-04-10.xls" etc and save the new version as above?

    That way you can always be linked to the latest version.
    If someone has helped you then please add to their Reputation

+ 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. Update cell links between 2 excel file without opening source file
    By ferry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2012, 03:03 PM
  2. Make checklist from closed WB's and then save updated C'List data back to source WB
    By Lungfish in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2011, 04:57 AM
  3. Highlight cell when source file is updated
    By ChinShiong in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-14-2010, 06:27 AM
  4. Refresh XML data in a Map if the source file is updated
    By nickTokyo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2009, 01:28 AM
  5. [SOLVED] Message: Links not updated because file not recalculated before sa
    By Carl Bowman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2005, 12:45 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