Refresh a PowerPivot table when its excel sheet is updated

Copper Contributor

Hi all,

I am trying to refresh a PowerPivot table when its excel sheet is updated without accessing to the model.
How could I do this?

It is to avoid users of this file to have to access PowerPivot (they dont know how to use it)

 

Thanks
julie

1 Reply

@JulieStamenic 

But they don't need Power Pivot, just Data->Refresh All on ribbon.