Excel 2003; spreadsheet with filtering; deleting rows

M

MHcoTech

Have a spreadsheet with 10k rows; filtering is on to identify duplicates; if
then stmt to id the duplicates; when I hilite to delete the selected rows
(roughly 3K at a time); it takes 4x as long as when we performed in a Excel
2002 on a Windows 2000 o/s.... Thoughts on the problem? OS is upgraded to a
WinXP pro latest sp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows autofilter range problem 5
Subtotals Deleting Rows after removing Subtotal - 2003 Excel 1
reference to worksheet fails if row deleted 7
How to delete blank rows at one time in a long excel spreadsheet? 2
Delete rows in filter view 1
Automatically Combine Cell Contents and Delete Rows 0
Auto delete a row after 5 weeks in Excel 1
delete only visible rows in filter mode 4

Top