title: Excel to Libreoffice macro conversion - RefreshTable
body: <p>I'm trying to run an Excel VBA macro from LibreOffice 7.1 that breaks here:</p>
  <pre><code>Dim pt As PivotTable
      For Each pt In ActiveSheet.PivotTables
          pt.RefreshTable 
      Next pt    
      ActiveSheet.Range(&quot;C3&quot;).Select
  
  End Sub
  </code></pre>
  <p>The function <code>pt.RefreshTable</code> aparently does not exists on calc's, does anyone know how can I replace it?</p>