/text/scalc/guide/datapilot_updatetable.xhp pivot table import pivot table function; refreshing tables recalculating;pivot tables updating;pivot tables Updating Pivot Tables If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose Data - Pivot Table - Refresh. Do the same after you have imported an Excel pivot table into $[officename] Calc.