can't collapse subtotaled data

[mic mac]

Hi all
I have office 2003, and have subtotaled some data on a excel sheet, however there is no way of collapsing it. I have done loads of subtotals before and always had the +++ on left that allowed me to collapse the data.
Given the list is 17000 I really need to know

cheers all

Mic

[Richard Buttrey]

Hi,

I think you'd be better advised to upload a cut down version of your workbook so that we can see your request in context. We don't need all 17000 rows just a representative sample.

Rgds

[mic mac]

AUTO AIR COMPRESSOR 1
AUTO AIR COMPRESSOR 1
AUTO AIR COMPRESSOR 2
AUTO AIR COMPRESSOR 1
AUTO AIR COMPRESSOR 1
AIR COMPRESSOR Total 6
AUTO ANTI FREEZE 4
AUTO ANTI FREEZE 12
AUTO ANTI FREEZE 2
AUTO ANTI FREEZE 2
AUTO ANTI FREEZE 2
AUTO ANTI FREEZE 2
AUTO ANTI FREEZE 1
AUTO ANTI FREEZE 1
AUTO ANTI FREEZE 2
ANTI FREEZE Total 28
AUTO AUTO ARIEL 7
AUTO AUTO ARIEL 1
AUTO ARIEL Total 8
AUTO AUTO BATTERY CHARGER 1
AUTO AUTO BATTERY CHARGER 1
AUTO AUTO BATTERY CHARGER 1
AUTO AUTO BATTERY CHARGER 1
AUTO AUTO BATTERY CHARGER 1
AUTO BATTERY CHARGER Total 5
AUTO AUTO BOOT PROTECTER 1
AUTO AUTO BOOT PROTECTER 1
AUTO AUTO BOOT PROTECTER 1
AUTO BOOT PROTECTER Total 3
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 1
AUTO AUTO BRAKE FLUID 2
AUTO AUTO BRAKE FLUID 2
AUTO BRAKE FLUID Total 11
AUTO AUTO BULB 1
AUTO AUTO BULB 1
AUTO AUTO BULB 1
AUTO AUTO BULB 1
AUTO AUTO BULB 1
AUTO AUTO BULB 4
AUTO AUTO BULB 2
AUTO AUTO BULB 1
AUTO AUTO BULB 2
AUTO AUTO BULB 1
AUTO AUTO BULB 2
AUTO AUTO BULB 1
AUTO AUTO BULB 1
AUTO BULB Total 19
AUTO AUTO CAR COVER 1
AUTO CAR COVER Total 1
AUTO AUTO CIGARETTE LIGHTER 2
AUTO AUTO CIGARETTE LIGHTER 3
AUTO AUTO CIGARETTE LIGHTER 1
AUTO AUTO CIGARETTE LIGHTER 1
AUTO AUTO CIGARETTE LIGHTER 1
AUTO AUTO CIGARETTE LIGHTER 1
AUTO AUTO CIGARETTE LIGHTER 1
AUTO CIGARETTE LIGHTER Total 10


I don't know if this helps...But usually when I subtotal I get three -/+ signs that allow me to expand and collapse the data, so it should read

Auto Air Compressor total 6
Auto Anti Freeze Total 28
Auto Auto Arial Total 8

...etc

Or if I collapse the third row....

Grand total 170000.

I have done subtotals so many times, and have never not had the collapse thing there?

cheers

Paul