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