Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default Row/Column Delete taking longer time

When I delete Columns & rows in Excel, I find the application taking a long
time to respond & many times , returns EXCEL NOT Responding. What could be
the reason.

I tried detect & repair feature. In reinstalled the Office 2003. But yet the
problem persists.

Any help please

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 527
Default Row/Column Delete taking longer time

Ananth

Sounds like a memory problem. Try saving the sheet before deleting.

Peter

"Ananth" wrote:

When I delete Columns & rows in Excel, I find the application taking a long
time to respond & many times , returns EXCEL NOT Responding. What could be
the reason.

I tried detect & repair feature. In reinstalled the Office 2003. But yet the
problem persists.

Any help please

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Row/Column Delete taking longer time

Hi

Do you have any formulae like
=SUM($A$1:A1)
copied down over a large range?
They can take an inordinate amount of to calculate, and can cause the
sort of problem you describe.
Try setting ToolsCalculationto Manual, carry out your deletions, then
set it back to Automatic.

--
Regards

Roger Govier


"Ananth" wrote in message
...
When I delete Columns & rows in Excel, I find the application taking a
long
time to respond & many times , returns EXCEL NOT Responding. What
could be
the reason.

I tried detect & repair feature. In reinstalled the Office 2003. But
yet the
problem persists.

Any help please



Reply
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
time format not taking new entry Liz McLean Excel Discussion (Misc queries) 4 April 23rd 07 09:34 PM
Taking out an Extra space before some entries in a column coastal Excel Discussion (Misc queries) 1 March 6th 07 10:14 PM
Sorting a Column and taking row information with it. Michaela Excel Worksheet Functions 2 November 20th 06 10:54 AM
how to stop emails incoming its taking a long time to download emails incoming New Users to Excel 1 June 25th 06 03:24 AM
Taking Columns that are horizaontial into a vretical column Jerry Arnone, PMP Excel Discussion (Misc queries) 1 June 18th 05 01:28 AM


All times are GMT +1. The time now is 12:41 AM.

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

About Us

"It's about Microsoft Excel"