How to Refresh Data -Automatic on daily basis - 2013

selvamg

New Member
Joined
Jul 30, 2019
Messages
6
Good Morning ,

We are using Office 2013.

We connected to Oracle DB , make query and make Power Pivot query -> All working ok

Now whenever we need to get the updated data - we are doing manually -Data -> Refresh All.

But we need to have 'Refresh Automatically' - For example say by 10 AM daily.

How to achieve this requirement.

Kindly guide with steps.

Thanks
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,088
Office Version
365
Platform
Windows
VBA option
- add the code
- save and close workbook as macro enabled
- opening the workbook triggers the macro at 10am on the same day

In standard module
Code:
Sub RefreshData()
    ThisWorkbook.RefreshAll
End Sub

In ThisWorkbook code area (does not work if placed in standard module)
Code:
Private Sub Workbook_Open()
    Application.OnTime TimeValue("10:00:00"), "RefreshData"
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,100,064
Messages
5,472,241
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top