+ Reply to Thread
Results 1 to 2 of 2

Update only one link when opening

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    Mobile,al
    MS-Off Ver
    Excel 2003
    Posts
    29

    Update only one link when opening

    I have a file that links to 31 other files to grab one value from each.
    The filepath for each is shown below, only the date changes for each.
    When my file updates all links it is rather slow and the user will frequently elect not to update at all.
    I'd like to have a code in place that would only update the file that corresponds to the date that the file is opened,for example today(7-10-11) when I open it I'd like to automatically update only the link below and so on.
    'H:\Morning Reports 2011\Jul\[7-10-11.xls]Production'!$AA$30)
    Hope this makes sense, if not I can clarify further.
    Any help will be appreciated as this will speed up the process and still get the info I need.
    Thanks in advance

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Update only one link when opening

    Cross posted as Synergetic at Ozgrid: http://www.ozgrid.com/forum/showthread.php?t=155876
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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