\<bookmark_value\>Pivot table import\</bookmark_value\>\<bookmark_value\>DataPilot function; refreshing tables\</bookmark_value\>\<bookmark_value\>recalculating;DataPilot tables\</bookmark_value\>\<bookmark_value\>updating;DataPilot tables\</bookmark_value\>

Updating Pivot Tables

If the data of the source sheet has been changed, Collabora Office recalculates the DataPilot table. To recalculate the tables, choose \<emph\>Data - DataPilot - Refresh\</emph\>. Do the same after you have imported an Excel Pivot table into Collabora Office Calc.