Excel automatic refresh every second

_{Monday, January 28, 2019 1:35 AM}

How to utomatic refresh every second in Excel?

_{Monday, January 28, 2019 3:34 AM ✅Answered}

You can auto refresh excel file every 1 second using VBA code

Sub Calculate_Range()

** Range(“A1:A5″).Calculate**

** Application.OnTime DateAdd(“s”, 1, Now), “Calculate_Range”**

End Sub

Please refer this article

Hope this helps!

Please don't forget to “mark the replies as answers” if they helped, also set "like" it’s a boost for us to keep blogging J

Click here to learn more. Visit the dedicated Community forum to share, explore and talk to experts about Microsoft Kaizala.

_{Monday, January 28, 2019 9:03 AM ✅Answered}

Hi,

Please try to use Macro to get the result:

Application.onTime Now + TimeValue("00:00:01")

Hope it's helpful.

Regards,

Emi

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact: [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

_{Tuesday, January 29, 2019 1:11 AM}

I will try this later..

Additional resources