+ Reply to Thread
Results 1 to 4 of 4

Refresh Progress Indicator Slowing down Query Refresh

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    London
    MS-Off Ver
    2016 Professional
    Posts
    50

    Refresh Progress Indicator Slowing down Query Refresh

    Dear All

    I have put together an indicator to show the user that Excel is still processing the query refresh and has not locked up etc, screen shot below.

    Capture.JPG

    The animation works fine except that it seriously increases the time taken to for the background query to refresh. I don't mind if it takes a bit longer or even doubles the time. I have posted the code below and I am wondering if there is better way to achieve this or structure the vba to help minimise the time taken.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Refresh Progress Indicator Slowing down Query Refresh

    Why don't you just use a static shape that says "Refreshing" until the refresh is complete?
    Rory

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Refresh Progress Indicator Slowing down Query Refresh

    Any extra processing you add will slow a macro since each step takes it's own time.
    VBA is sequential so the next row won't run until the previous is completed.
    Things tha 'look nice' can foul up other processes.
    Like @rorya says A static image or the status bar indication progress if needed is the best option

    Excel as of 2007 has the nasty habit of 'not responding' while it really is still busy, so the animated image looks locked, but actually Excel is working in the background even if the Caption tells you 'Not responding'

    Go drink a cup of coffee (or tea) and come back and you'll see it's completed (unless an error occurred of course)
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Refresh Progress Indicator Slowing down Query Refresh

    BTW wya you can also change the mouse cursor to Wait, Google for that, is a nice touch too

+ 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. Add Progress Bar to Connection Refresh Query
    By vibajajo64 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-07-2018, 02:16 AM
  2. Progress indicator or countdown timer while refresh macro is running
    By DanGres in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 09:21 PM
  3. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  4. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  5. [SOLVED] Query parameter "refresh when value changes" doesn't refresh - why
    By Texas_Toast in forum Excel General
    Replies: 0
    Last Post: 01-04-2006, 11:35 AM
  6. [SOLVED] Query Refresh capturing rows returned to display progress
    By Stewart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2005, 12:05 PM
  7. Query Refresh-Enable Automatic Refresh Dialogue Box
    By Terri in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 04:06 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