Results 1 to 4 of 4

Thread: Excel Refresh All Stopped Working

  1. #1
    Neophyte glennm0270's Avatar
    Join Date
    Nov 2017
    Location
    Charlotte, NC
    Posts
    4
    Articles
    0
    Excel Version
    Win: 1803, Mac: 16.17 (180909)

    Excel Refresh All Stopped Working



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Sometime in the last week or so, the Data / Refresh All action stopped working in Excel on one of my Windows machines. I click Data / Refresh All (or Data / Refresh All / Refresh All) and nothing happens. Used to be that I got the message about background queries running, then all the data tables refreshed. If I had the Connections sidebar open, I could see the tables updating.

    Now, all of a sudden, nothing happens when I click it. I can go through the queries and do Refresh one at a time, and they work fine. Wondering if a recent Office update may have messed up something? I'm on monthly channel and auto-update. On the other hand, I have Office installed on another machine, and Data / Refresh All continues to work just fine.


    Appreciate any suggestions for how I might dig into this and correct.

  2. #2
    Neophyte glennm0270's Avatar
    Join Date
    Nov 2017
    Location
    Charlotte, NC
    Posts
    4
    Articles
    0
    Excel Version
    Win: 1803, Mac: 16.17 (180909)
    Okay, I finally found the answer. I had to install MySQL Workbench recently. It installed the MySQL Excel Add-In (I didn't remember asking for that, but I may have...or may not). Turns out that breaks the Data / Refresh All. I uninstalled that add-in, and things are working great now.

  3. #3
    Seeker masterswordz's Avatar
    Join Date
    Apr 2020
    Location
    Philippines
    Posts
    19
    Articles
    0
    Excel Version
    2016
    Or maybe you may check Connection Properties.

    Data > Connection Properties > Tick "Refresh this connection on Refresh All"

  4. #4
    Neophyte glennm0270's Avatar
    Join Date
    Nov 2017
    Location
    Charlotte, NC
    Posts
    4
    Articles
    0
    Excel Version
    Win: 1803, Mac: 16.17 (180909)
    Quote Originally Posted by masterswordz View Post
    Or maybe you may check Connection Properties.

    Data > Connection Properties > Tick "Refresh this connection on Refresh All"
    Appreciate the suggestion, but that was the first thing I checked :-) There are about a dozen queries in the first workbook that stopped working, and about a dozen other workbooks with multiple queries in each of them. They all had been working for over a year and all suddenly stopped at the same time, so that was another hint that it wasn't a setting on one of the queries.

    Thanks again for the tip though--it was definitely the right place to start!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •