| 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 |
| 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 | |||
Threaded Mode
