+ Reply to Thread
Results 1 to 4 of 4

Refresh existing connections of multiple workbooks.

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    114

    Refresh existing connections of multiple workbooks.

    Hello,
    I have a folder containing 30 files/workbooks. Each workbook contains a tab that links to individual text files that I refresh/update each month. I am trying to avoid having to open each file and refresh each data set.
    For clarity, each file pertains to a model that focuses on one US state (AL.xlsm, AZ.xlsm, etc). A tab exists in each file (“Sheet1” in each case) that links to a text file (AL.txt, AZ.txt, etc) “Sheet1” of each state model currently updates by hitting “Refresh” in each file. FWIW the linked text files are created by SAS and re-run each month.
    I’m trying to update each state model in one swoop without opening and/or “refreshing” each one.

    Any help is appreciated.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: Refresh existing connections of multiple workbooks.

    maybe use built-in feature

    connection.jpg

    set it for every file once and forget it
    I suggest point 2
    Last edited by sandy666; 04-29-2018 at 06:20 PM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Contributor
    Join Date
    10-24-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: Refresh existing connections of multiple workbooks.

    Thanks, I’ll give this a try in the morning. How do I get the window shown in the jpeg to show? I’m sure it’s easy to find, it just doesn’t look familiar.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Refresh existing connections of multiple workbooks.

    Hm, I don't remeber Ex2007 but maybe under Data tab (Alt+A+O) -Connection - Properties
    maybe someone with Ex2007 will give you easiet way

    maybe it will help
    Connection
    Last edited by sandy666; 04-29-2018 at 06:51 PM.

+ 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. [SOLVED] Refresh Existing Connections Workbook- read Only Problem
    By Keibri in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-29-2018, 12:45 PM
  2. [SOLVED] Macro to refresh connections and add formulas
    By PWNHS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2018, 05:25 AM
  3. Refresh All vs. Refresh All Data Connections
    By TK92 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2016, 09:14 AM
  4. Refresh Specific Sheets/ Connections
    By hyp3rbola in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 04:50 PM
  5. [SOLVED] Data Tab -- Refresh All data Connections on multiple sheets - Need a macro
    By aetedford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2013, 06:40 PM
  6. Macro to Refresh data Connections in each Tab of an excel
    By pnandak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 04:47 AM
  7. Replies: 2
    Last Post: 03-12-2010, 12:47 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