Sep 15 2019 04:05 PM
Hello ,
Can someone please suggest how to refresh imported data(table in PowerPivot window. it has option to refresh manually using existing connection.. I am willing not to open PowerPivot Window & refresh using VBA like commands.
Sep 15 2019 04:31 PM
Hi
You can create a simple cod and attach it to the Open event of the workbook, as follows:
Private Sub Workbook_Open()
ThisWorkbook.RefreshAll
End Sub
Hope that helps
Nabil Mourad