title: Is it posible to refresh a powerpivot table with a macro in a version of excel without powerpivot?
body: <p>I now that this is more of a license question than a programming question but I couldnt find the answer anywhere.</p>
  
  <p>I have made a powerpivot workbook which I send around amongst colleagues but some of them can't refresh the data and I can't find why. Is it possible that they need a version of excel 2013 which supports powerpivot? Otherwise the workbooks work well for them, i.e. they can use the slicers and trim down the data and look at the graphs an so on.</p>
  
  <p>The macro which refreshes the data is:</p>
  
  <pre><code>ActiveSheet.PivotTables("table name").PivotCache.refresh
  </code></pre>
  
  <p>If it is a problem with the macro, can I do the refresh in a different way?</p>