Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003: Slow Response on ClearContents
When I use ClearContents in Excel 2003 I get a very slow response, when
clearing many rows. For example, if I clear about 30 columns and 30,000 rows, it might take 10 minutes. If I run the same procedure For example: Range("A1:AD30000").ClearContents on a different computer, it takes less than a second. What is going on? I have looked through all the settings, but do not see anything obvious. I am using XP-Pro, with a 2.66 Mhz dual core Xeon processor, with 2 GB of ram, and so the system should not be an issue. This problem began suddenly several months ago and has persisted through a reinstall of Office 2003. It is driving me crazy. Thanks, Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow response opening Formats? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Response | Setting up and Configuration of Excel | |||
Formula Yields Slow response | Excel Programming | |||
Slow Response time | Excel Programming | |||
Slow Response time | Excel Programming |