View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default Clearing cells takes long, long time

In . com,
unclemuffin spake thusly:

I am using Excel 2007 and I have a sheet that has about 22,000 rows of
data. When I try to delete the data by all of the following methods
it takes well over three minutes to complete:


Try going into Options / Calculation and switching it to manual
mode.

If that helps, you can turn calculation mode off in a macro that helps
you delete, then turn it back on.

=dman=