View Single Post
 
Old 11-23-2017, 10:18 AM
ramzan11b ramzan11b is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2017
Posts: 1
ramzan11b is on a distinguished road
Default Macro for automatically refreshing Data connection on Closed excel workbook.

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.
Reply With Quote