Updating Pivot Tables
If the data of the source sheet has been changed, Collabora Office 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 Collabora Office Calc.
Open file with example: