Autorefreshing Powerpivot

Highlighted
Occasional Visitor

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.

1 Reply
Highlighted

@Deva1615 

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