Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Del is Slow
I am handling a worksheet that has 30000 rows. I use the DEL key to delete
the row, instead of using Delete Rows Command in the EXcel Menu. Excel is annoyingly slow and sometimes does not respond. What is the solution Ananth |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Del is Slow
Ananth,
A lot depends on what you don't say.. Set Excel's calculation mode to manual.... Use a macro... Sort the table on your deleting key, and delete all the rows as one block.... Remove links... Convert formulas to values... HTH, Bernie MS Excel MVP "Ananth" wrote in message ... I am handling a worksheet that has 30000 rows. I use the DEL key to delete the row, instead of using Delete Rows Command in the EXcel Menu. Excel is annoyingly slow and sometimes does not respond. What is the solution Ananth |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why Del is Slow
Perhaps try turn off Automatic Calculation, and see if that is what is
using the time. Ananth wrote: I am handling a worksheet that has 30000 rows. I use the DEL key to delete the row, instead of using Delete Rows Command in the EXcel Menu. Excel is annoyingly slow and sometimes does not respond. What is the solution Ananth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VERY SLOW VERY after an ADD ON | Excel Discussion (Misc queries) | |||
Slow opening | Excel Discussion (Misc queries) | |||
Why so slow | Excel Discussion (Misc queries) | |||
Slow Calculations | Excel Discussion (Misc queries) | |||
How come replace is so slow? | Excel Discussion (Misc queries) |