excel file performance slow

[Guest]

Hi all. Whenever i try to edit a particular excel file, the process of
editing this file would be very slow. The file is only 800KB and while
editing this file my pc memory usage and cpu usage looks normal. Other excel
files are ok. I have since done repair and install updates but to no avail.
Why is this so? Thks in advance.

 

[Guest]

If you have too many formulas then it may affect on file performance. You can
set calculation mode to manual. Also, check if your file contains any dirty
cells. You can remove dirty cells to improve performace.

 

[Guest]

Hi Himani,

Thks for your response.
I know how to set calculation mode to manual but how do i identify and
remove dirty cells? Thks in advance.