Share via

Auto Refreshing Data in excel with SQL Database

Onlxy 1 Reputation point
2020-08-27T23:37:39.653+00:00

Hello,

Is there a way for me to code my excel workbook that is connected to SQL server to automatically refresh (for example cell A to D) every 1 mins, Friday to Sunday, from 8 am-4 pm, using SQl code, Power query or VBA code.

Thanks

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,994 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-08-28T07:34:29.693+00:00

    Hi @Onlxy ,

    Is there a way for me to code my excel workbook that is connected to SQL server to automatically refresh (for example cell A to D) every 1 mins, Friday to Sunday, from 8 am-4 pm, using SQl code, Power query or VBA code.

    Yes. Please reference: https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440
    And btw, how do you design your system, do you use power bi? Or just save data from sql server to excel?

    BR,
    Mia
    If the reply is helped, please do “Accept Answer”.--Mia