You may want to consider using pivottables.

But I'd try turning calculation to manual, then remove the subtotals, then turn
it back to what it was (automatic??).

In xl2003 menus:
tools|options|calculation tab
is where you'd find this setting.

Rajesh Kodethoor wrote:

I am using a file with more than 10000 lines, i have used subtotal function &
when I remove the subtoal its taking a lot time to remove, is there any
solution to this?

--

Dave Peterson