Updating Pivot Tables
If the data of the source sheet has been changed, Cool Office Suite 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 Cool Office Suite Calc.