LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow response opening Formats? blueshoes9001 Excel Discussion (Misc queries) 6 October 30th 07 01:24 PM
Excel 2003 Slow Response kbk_kbk_kbk Setting up and Configuration of Excel 1 April 16th 06 08:21 PM
Formula Yields Slow response Steve Excel Programming 0 November 15th 04 02:58 PM
Slow Response time Rob Bovey Excel Programming 0 August 11th 03 03:47 AM
Slow Response time Carl Brehm Excel Programming 3 August 10th 03 07:10 AM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"