Don't know why: excel was unable to update the PivotTable on the worksheet while my colleagues can

Stella_Zheng 

If there are cells in use below or to the right of the pivot table, either clear those cells or move them out of the way, then try refreshing the pivot table again.