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

Check you worksheet code modules for Worksheet_Change code, or any code in
the stanadard module or formulas in the worksheet cells that might trigger
from changes in the cells value and would recalculate.

"RCL2884" wrote:

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

On Nov 29, 9:47 am, JLGWhiz wrote:
Check you worksheet code modules for Worksheet_Change code, or any code in
the stanadard module or formulas in the worksheet cells that might trigger
from changes in the cells value and would recalculate.


Thanks for the reply. As far as I can tell I do not have any reference
to Worksheet_Change in any modules. I note that the delay on
ClearContents occurs even when automatic calculation is set to False.
Another clue... it takes longer to clear cells the farther down on the
sheet I go. For example, rows 1-100 clear quickly, but rows
20001-20100 take a long time.

On Nov 29, 10:05 am, wrote:
When I useClearContentsin Excel2003I get a veryslowresponse, 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

I have found a solution to this problem (sort of). The delay is
eliminated if I issue the following command before clearing the cells.

Application.EnableEvents = False

As I understand it, an "Event" is something like opening or closing a
sheet, or other things such as clicking on or changing a cell, etc. I
have not added any code pertaining to eny event and so I am not sure
why disabling the event checking should work. As I mentioned, this
problem occurs on some computers and not others, regardless of what
workbook is open, and so it must relate to a general or global
setting. I cannot find anything in the various options that seems
relevant. Any suggestions of where to look? Since the slow response
occurs even when I clear cells in the sheet (and not by using a macro)
I would like to be able to change a setting that eliminates the
problem for good.

Thanks in advance for any suggestions.
....Rick

Hi Rick,

Do you have Excel 2007 installed?
If you do not have it installed then I think its something to do with
updating the system with Microsoft Update.

Anyway Enablevents=False seems to solve the problem

Charles
_________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

wrote in message
...
On Nov 29, 10:05 am, wrote:
When I useClearContentsin Excel2003I get a veryslowresponse, 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

I have found a solution to this problem (sort of). The delay is
eliminated if I issue the following command before clearing the cells.

Application.EnableEvents = False

As I understand it, an "Event" is something like opening or closing a
sheet, or other things such as clicking on or changing a cell, etc. I
have not added any code pertaining to eny event and so I am not sure
why disabling the event checking should work. As I mentioned, this
problem occurs on some computers and not others, regardless of what
workbook is open, and so it must relate to a general or global
setting. I cannot find anything in the various options that seems
relevant. Any suggestions of where to look? Since the slow response
occurs even when I clear cells in the sheet (and not by using a macro)
I would like to be able to change a setting that eliminates the
problem for good.

Thanks in advance for any suggestions.
...Rick

On Dec 1, 4:47 pm, "Charles Williams"
wrote:
Hi Rick,

Do you have Excel 2007 installed?
If you do not have it installed then I think its something to do with
updating the system with Microsoft Update.


Nope... I am using Excel 2003 that has been fully updated. When the
problem first occurred a couple of months ago, I thought it might be
due to a recently installed update, and so I backed out the update,
but to no effect. I also reinstalled Excel 2003, and this did not
help. I will stop perseverating on this since I have a work-around. I
just wish I understood what is happening.
....Rick