Updating DataPilot Tables
If the data of the source sheet has been changed, LibreOffice recalculates the DataPilot table. To recalculate the tables, choose Data - DataPilot - Refresh. Do the same after you have imported an Excel Pivot table into LibreOffice Calc.
Open file with example: