+ Reply to Thread
Results 1 to 4 of 4

Altering Query Refresh

  1. #1
    Forum Contributor
    Join Date
    09-18-2014
    Location
    England
    MS-Off Ver
    2003/2010/365
    Posts
    119

    Lightbulb Altering Query Refresh

    Hi,

    I set up a data query via:

    Data > Get External Data > From Other Sources > From Microsoft Query

    When I set this up, I opted to refresh the data myself. I now wish to alter this to update the query everytime the document is opened.

    Does anybody know how I can change this?

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    09-18-2014
    Location
    England
    MS-Off Ver
    2003/2010/365
    Posts
    119

    Re: Altering Query Refresh

    Bump for reply.

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,247

    Re: Altering Query Refresh

    Select the Data tab, click the Connections button, select your connection and click Properties, then you can specify when to update.
    Remember what the dormouse said
    Feed your head

  4. #4
    Forum Contributor
    Join Date
    09-18-2014
    Location
    England
    MS-Off Ver
    2003/2010/365
    Posts
    119

    Re: Altering Query Refresh

    Thank you

+ 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. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  2. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  3. Replies: 0
    Last Post: 03-26-2013, 04:38 PM
  4. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  5. Query Refresh-Enable Automatic Refresh Dialogue Box
    By Terri in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 04:06 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