During External Connection refresh, show what's shown in the bottom bar in a dialog window (or something similar)

Nola111

Board Regular
Joined
Aug 28, 2013
Messages
119
I wasn't sure which subforum was more appropriate for this question between this and the Excel one, so let's try this one:

Excel M365 latest version - when I Refresh All Connections in my file,, it takes about 5 minutes to fully refresh and pull everything in. The indicator that something is happening during this 5 minutes is on the bottom bar of the Excel window - it says "Running background query... click here to cancel." I'm going to need to make this message (or a similar message) much more apparent and visible to my users. Is there any way to display this in a dialog box/window, preferably with some kind of spinning wheel, indicating that something is happening? Even if it's not that exact message, I need to just be able to have a very obvious window up informing the user that the connection is refreshing, with a spinning wheel, that closes when the refresh is complete. No timer needed, no percentage needed, just a spinning wheel with a message that closes after refresh completion.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,757
Messages
6,174,330
Members
452,555
Latest member
colc007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top