Deleting rows in Excel 2003 now takes several minutes. Why?

[Guest]

Excel 2003 wasn't like this previously - it just started to happen a few
weeks ago. The problem seems to occur in only one of my spreadsheets. It's
like the program iis in a loop, or something like that. I have installed all
Microsoft updates the Excel.

 

[Guest]

Hi,

Are you deleting more than one row at a time and if so how are you picking
those rows. Also, are you in [Group] mode?

 

[Guest]

I'm having the same problem, but with Excel 2007 which I recently installed.
One at a time is OK, but anything over about 1000 rows is an issue. It
doesn't matter how they are selected, filtered or unfiltered (but usually I
select a row and ctrl+shft+down arrow). I noticed the problem originally when
running a macro that worked perfectly fine before I upgraded. I have the same
issue doing it manually.

It actually seems to be an issue with selecting a lot of rows. An accidental
ctrl+shift+down arrow in a column that isn't populated all the way to the end
of the data can really put a damper on being able to get anything done. I am
working in compatibility mode so there's only 65536 rows, so it isn't a
matter of dealing with 1M+ rows.

Hi,

Are you deleting more than one row at a time and if so how are you picking
those rows. Also, are you in [Group] mode?

--
Thanks,
Shane Devenshire

Excel 2003 wasn't like this previously - it just started to happen a few
weeks ago. The problem seems to occur in only one of my spreadsheets. It's
like the program iis in a loop, or something like that. I have installed all
Microsoft updates the Excel.

 

[Guest]

Let's test to see if this is an Excel problem or a file problem:

1. Open a blank workbook, (no other spreadsheets open)
2. In cell A1 enter the following formula
=1/MOD(ROW(),2)
3. Copy this formula down 2000 rows to A2000.
4. Select all the formulas and choose Copy
5. Then choose Edit, Paste Special, Values
6. Press F5, click Special and, Constants.
7. Under Constants uncheck all except Numbers and click OK
8. Press Ctrl - (minus) and respond Entire row, OK.

You might make the same test with only Excel open and with other
applications you normally use open and note if there is a difference.

Note if this takes as long as your row deletions have been taking. Note you
are deleting 1000 rows and they are on alternate lines. On my computer this
takes about a second or less. I am running VISTA Ultimate, on a dual core
2.26MHz machine with 2 GB of RAM. I tested this with Excel 2003 and 2007.
It might be slightly slower under 2007, but its minor.

If this is fast on your machines then the problem is probably related to
your files or to how many other applications you have open. Let us know your
results.
--
Thanks,
Shane Devenshire

I'm having the same problem, but with Excel 2007 which I recently installed.
One at a time is OK, but anything over about 1000 rows is an issue. It
doesn't matter how they are selected, filtered or unfiltered (but usually I
select a row and ctrl+shft+down arrow). I noticed the problem originally when
running a macro that worked perfectly fine before I upgraded. I have the same
issue doing it manually.

It actually seems to be an issue with selecting a lot of rows. An accidental
ctrl+shift+down arrow in a column that isn't populated all the way to the end
of the data can really put a damper on being able to get anything done. I am
working in compatibility mode so there's only 65536 rows, so it isn't a
matter of dealing with 1M+ rows.

Hi,

Are you deleting more than one row at a time and if so how are you picking
those rows. Also, are you in [Group] mode?

--
Thanks,
Shane Devenshire

Excel 2003 wasn't like this previously - it just started to happen a few
weeks ago. The problem seems to occur in only one of my spreadsheets. It's
like the program iis in a loop, or something like that. I have installed all
Microsoft updates the Excel.

 

[Guest]

Let's test to see if this is an Excel problem or a file problem:

1. Open a blank workbook, (no other spreadsheets open)
2. In cell A1 enter the following formula
=1/MOD(ROW(),2)
3. Copy this formula down 2000 rows to A2000.
4. Select all the formulas and choose Copy
5. Then choose Edit, Paste Special, Values
6. Press F5, click Special and, Constants.
7. Under Constants uncheck all except Numbers and click OK
8. Press Ctrl - (minus) and respond Entire row, OK.

You might make the same test with only Excel open and with other
applications you normally use open and note if there is a difference.

Note if this takes as long as your row deletions have been taking. Note you
are deleting 1000 rows and they are on alternate lines. On my computer this
takes about a second or less. I am running VISTA Ultimate, on a dual core
2.26MHz machine with 2 GB of RAM. I tested this with Excel 2003 and 2007.
It might be slightly slower under 2007, but its minor.

If this is fast on your machines then the problem is probably related to
your files or to how many other applications you have open. Let us know your
results.
--
Thanks,
Shane Devenshire

I'm having the same problem, but with Excel 2007 which I recently installed.
One at a time is OK, but anything over about 1000 rows is an issue. It
doesn't matter how they are selected, filtered or unfiltered (but usually I
select a row and ctrl+shft+down arrow). I noticed the problem originally when
running a macro that worked perfectly fine before I upgraded. I have the same
issue doing it manually.

It actually seems to be an issue with selecting a lot of rows. An accidental
ctrl+shift+down arrow in a column that isn't populated all the way to the end
of the data can really put a damper on being able to get anything done. I am
working in compatibility mode so there's only 65536 rows, so it isn't a
matter of dealing with 1M+ rows.

Hi,

Are you deleting more than one row at a time and if so how are you picking
those rows. Also, are you in [Group] mode?

--
Thanks,
Shane Devenshire


:

Excel 2003 wasn't like this previously - it just started to happen a few
weeks ago. The problem seems to occur in only one of my spreadsheets. It's
like the program iis in a loop, or something like that. I have installed all
Microsoft updates the Excel.

 

[Guest]

I tried the test you suggested below. The rows deleted in about 1 second, so
I think the problem is with my spreadsheet, as you stated. I just wish I
could discover where the problem is.

Let's test to see if this is an Excel problem or a file problem:

1. Open a blank workbook, (no other spreadsheets open)
2. In cell A1 enter the following formula
=1/MOD(ROW(),2)
3. Copy this formula down 2000 rows to A2000.
4. Select all the formulas and choose Copy
5. Then choose Edit, Paste Special, Values
6. Press F5, click Special and, Constants.
7. Under Constants uncheck all except Numbers and click OK
8. Press Ctrl - (minus) and respond Entire row, OK.

You might make the same test with only Excel open and with other
applications you normally use open and note if there is a difference.

Note if this takes as long as your row deletions have been taking. Note you
are deleting 1000 rows and they are on alternate lines. On my computer this
takes about a second or less. I am running VISTA Ultimate, on a dual core
2.26MHz machine with 2 GB of RAM. I tested this with Excel 2003 and 2007.
It might be slightly slower under 2007, but its minor.

If this is fast on your machines then the problem is probably related to
your files or to how many other applications you have open. Let us know your
results.
--
Thanks,
Shane Devenshire

I'm having the same problem, but with Excel 2007 which I recently installed.
One at a time is OK, but anything over about 1000 rows is an issue. It
doesn't matter how they are selected, filtered or unfiltered (but usually I
select a row and ctrl+shft+down arrow). I noticed the problem originally when
running a macro that worked perfectly fine before I upgraded. I have the same
issue doing it manually.

It actually seems to be an issue with selecting a lot of rows. An accidental
ctrl+shift+down arrow in a column that isn't populated all the way to the end
of the data can really put a damper on being able to get anything done. I am
working in compatibility mode so there's only 65536 rows, so it isn't a
matter of dealing with 1M+ rows.

Hi,

Are you deleting more than one row at a time and if so how are you picking
those rows. Also, are you in [Group] mode?

--
Thanks,
Shane Devenshire


:

Excel 2003 wasn't like this previously - it just started to happen a few
weeks ago. The problem seems to occur in only one of my spreadsheets. It's
like the program iis in a loop, or something like that. I have installed all
Microsoft updates the Excel.

 

[Guest]

It worked in no time for me too. I'm going to have to dig a little deeper.

Thank you for your help,
Cathy

Let's test to see if this is an Excel problem or a file problem:

1. Open a blank workbook, (no other spreadsheets open)
2. In cell A1 enter the following formula
=1/MOD(ROW(),2)
3. Copy this formula down 2000 rows to A2000.
4. Select all the formulas and choose Copy
5. Then choose Edit, Paste Special, Values
6. Press F5, click Special and, Constants.
7. Under Constants uncheck all except Numbers and click OK
8. Press Ctrl - (minus) and respond Entire row, OK.

You might make the same test with only Excel open and with other
applications you normally use open and note if there is a difference.

Note if this takes as long as your row deletions have been taking. Note you
are deleting 1000 rows and they are on alternate lines. On my computer this
takes about a second or less. I am running VISTA Ultimate, on a dual core
2.26MHz machine with 2 GB of RAM. I tested this with Excel 2003 and 2007.
It might be slightly slower under 2007, but its minor.

If this is fast on your machines then the problem is probably related to
your files or to how many other applications you have open. Let us know your
results.
--
Thanks,
Shane Devenshire

I'm having the same problem, but with Excel 2007 which I recently installed.
One at a time is OK, but anything over about 1000 rows is an issue. It
doesn't matter how they are selected, filtered or unfiltered (but usually I
select a row and ctrl+shft+down arrow). I noticed the problem originally when
running a macro that worked perfectly fine before I upgraded. I have the same
issue doing it manually.

It actually seems to be an issue with selecting a lot of rows. An accidental
ctrl+shift+down arrow in a column that isn't populated all the way to the end
of the data can really put a damper on being able to get anything done. I am
working in compatibility mode so there's only 65536 rows, so it isn't a
matter of dealing with 1M+ rows.

Hi,

Are you deleting more than one row at a time and if so how are you picking
those rows. Also, are you in [Group] mode?

--
Thanks,
Shane Devenshire


:

Excel 2003 wasn't like this previously - it just started to happen a few
weeks ago. The problem seems to occur in only one of my spreadsheets. It's
like the program iis in a loop, or something like that. I have installed all
Microsoft updates the Excel.