How to Refresh Data -Automatic on daily basis - 2013

[selvamg]

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

 

[Yongle]

This should help

https://support.office.com/en-us/ar...ted-data-e76a38b0-e2e1-400b-9f2f-c87b9b18c092
click on see Automatically refresh data at regular intervals

 

[Yongle]

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

Sub RefreshData()
    ThisWorkbook.RefreshAll
End Sub

In ThisWorkbook code area (does not work if placed in standard module)

Private Sub Workbook_Open()
    Application.OnTime TimeValue("10:00:00"), "RefreshData"
End Sub