Recently got a very useful addition to Excel, which in real time receives data from the servers and writes to Excel.
However, to refresh the data click on the Refresh button (Main menu-Tab add-on).
You can write a macro that will every 1-2 minutes to click on this button.
Google only answers how to attach a macro to the button, but it's generally not.