excel file performance slow

I

inenewbl

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.
 
H

Himani

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.
 
I

inenewbl

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top