+ Reply to Thread
Results 1 to 4 of 4

Update by time intervals

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    UK
    MS-Off Ver
    MS 365 Apps for Enterprise
    Posts
    64

    Update by time intervals

    Hi there,

    I have a file that grabs data from 15 other files, and them from it. If I alter data in 1 of the 15 files, I need to update the main file upon opening or vice versa. Is it possible to get the main file (or all 16 files) to update at chosen times of day or time intervals? This would really be useful as I do not touch the 15 smaller files - and it is hard to trust others to use them correctly!!!

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Update by time intervals

    It's possible as long as you leave the main file open.
    See "OnTime" in help.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

  3. #3
    Registered User
    Join Date
    09-28-2008
    Location
    UK
    MS-Off Ver
    MS 365 Apps for Enterprise
    Posts
    64

    Re: Update by time intervals

    Thanks for that,

    But that is precisely the problem - it won't be open.

  4. #4
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Update by time intervals

    Hi kiboodez;

    I just discovered this thread in my subscriptions. Sorry for not answering earlier.

    Don't know if you're still looking for an answer.
    The thread isn't marked "Solved", but I don't want to waste your time if you're satisfied.

+ 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