Hy all.
I need some help.
I will be very grateful and will pray-full for any help.
I don't know about using macros in excel.

I am using excel 2013. I have a workbook which has connections to SQL Server for power query and pivot tables.
I want that the data connections in work book may be refreshed at specific time intervals and workbook may be saved.
Can some one please guide me for adding and enabling macro for this purpose.


I am completely raw in adding macro. So please someone guide me completely with some example.
I will be very much grateful for this help.

Create a vb-script which opens your Excel workbook (maybe without displaying it at all), refreshes the query, and then saves and closes the workbook. And then run this script by Windows scheduled task.

Btw. Why you need to automate this at all? When someone uses the workbook to see the data, then you can set the query to SQL Server to be refreshed on open. When you query the data in Excel workbook, then why not query the data from SQL Server directly?