too Slow...!!!!

[S. Obaid]

I have an excel sheet containing records
not more than 1000 in A-T columns...
I am using Fliter on this sheet and Also
getting the same data on other sheet with
vlookup formula...

My file was working very nicely.. no problem
in opening editing printing.all was quick now
I have to wait approx 3 seconds just to move
to next cell..!!!!!! its taking too much time in
any action....

Plz help me....

Syed Obaid

 

[Peo Sjoblom]

Since you said it worked OK once, try to press ctrl + end and see
where it takes you, it should be the last cell with data. If it's way off
from what you have
select all rows below (ctrl shift and down arrow) and do edit>delete, press
ctrl + home
and save the workbook, now select all columns to the right of the last data
and repeat.
For general speed questions see

http://www.decisionmodels.com/calcsecrets.htm
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)