Excel File long time to save

[ongengthai1973]

Hi,
I need help. Currently I am using Excel file and save in format "Microsoft Excel Binary Worksheet". Normally I am opening A,B,C & D Excel files in one time when working my assignment.

Without open Files A- File B, C & D saving file time no issue.

When I am opening File A, saving file B, C & D the saving file time very long. I noticed file A is the root cause to slow down others files. File A having lots of formulas and file size is just 781KB.
Question- Is there any way to reduce the file size or any others way to speed-up saving for others files (File B,C & D) while I opening file A?

Thank you.

 

[mumps]

Try manually changing formula calculation to manual before saving the files and after saving, change formula calculation back to automatic.