Refresh a PowerPivot table when its excel sheet is updated

%3CLINGO-SUB%20id%3D%22lingo-sub-1385999%22%20slang%3D%22en-US%22%3ERefresh%20a%20PowerPivot%20table%20when%20its%20excel%20sheet%20is%20updated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385999%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20refresh%20a%20PowerPivot%20table%20when%20its%20excel%20sheet%20is%20updated%20without%20accessing%20to%20the%20model.%3CBR%20%2F%3EHow%20could%20I%20do%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20is%20to%20avoid%20users%20of%20this%20file%20to%20have%20to%20access%20PowerPivot%20(they%20dont%20know%20how%20to%20use%20it)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3CBR%20%2F%3Ejulie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1385999%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386062%22%20slang%3D%22en-US%22%3ERe%3A%20Refresh%20a%20PowerPivot%20table%20when%20its%20excel%20sheet%20is%20updated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544629%22%20target%3D%22_blank%22%3E%40JulieStamenic%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20they%20don't%20need%20Power%20Pivot%2C%20just%20Data-%26gt%3BRefresh%20All%20on%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@JulieStamenic 

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