Long Time Taken In Excel Synchronization

[JERRY89]

Hi All,

I do have an excel file that contain multiple of excel sheet that have pivot table,sum product and etc formula used in a workbook.The problem is whenever i need to insert row in a column below or even save the data,my workbook using quite a long time to synchronize before this action taken place.So is there any tips for us that having such workbook that contain many sheet and formula from being synchronize so long.

[HansV]

lots of tips here: Excel 2010 Performance: Tips for Optimizing Performance Obstructions