Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How come replace is so slow?
Every month I edit a worksheet with 22,000 rows.
I take 2 columns, hit find and replace, and change all blank cells to zeros. In Excel XP it would take 3 seconds. Now it takes 3 minutes. This is unacceptable, but I haven't found a fix or another reference to this problem. Anyone know a way I get get Excel to do it's job? Thanks, Nathan |
#2
|
|||
|
|||
Hi Nathan
Try it with calculation = manual ToolsOptions..Calculation If you have a change event in the sheet it is also possible that it is very slow -- Regards Ron de Bruin http://www.rondebruin.nl "Nathan" wrote in message ... Every month I edit a worksheet with 22,000 rows. I take 2 columns, hit find and replace, and change all blank cells to zeros. In Excel XP it would take 3 seconds. Now it takes 3 minutes. This is unacceptable, but I haven't found a fix or another reference to this problem. Anyone know a way I get get Excel to do it's job? Thanks, Nathan |
#3
|
|||
|
|||
Thank's for the suggestion, but alas it still takes 3 minutes (there are no
calculations at this early step, it's just text), instead of 3 seconds. I don't know why this is suddenly a problem in Excel 2003, but not in all previous versions... "Ron de Bruin" wrote: Hi Nathan Try it with calculation = manual ToolsOptions..Calculation If you have a change event in the sheet it is also possible that it is very slow -- Regards Ron de Bruin http://www.rondebruin.nl "Nathan" wrote in message ... Every month I edit a worksheet with 22,000 rows. I take 2 columns, hit find and replace, and change all blank cells to zeros. In Excel XP it would take 3 seconds. Now it takes 3 minutes. This is unacceptable, but I haven't found a fix or another reference to this problem. Anyone know a way I get get Excel to do it's job? Thanks, Nathan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
Word: replace ... ... with space | Excel Discussion (Misc queries) | |||
find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Replace using wildcards | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |