Thanks Stefi thats exactly what I did but when I deleted everything but
the new sheet with just the the subtotals that I copied to a new
worksheet the workbook still had a size of over 6 meg. Bernard's
solution worked.

gls858

Stefi wrote:
Try this (sorry if some terms does not match the original English ones, I'm
translating them back from Hungarian):
Choose level 2 of subtotal display (click on 2 of 1 2 3 in the top left
corner of the sheet)! You see subtotal rows only.
Edit/Jump (CTRL+G)/Advanced selection (bottom left button)/Current area
Leave selection unchanged!
Edit/Jump (CTRL+G)/Advanced selection (bottom left button)/Visible cells only
Copy and paste!

Regards,
Stefi



€žgls858€� ezt Ã*rta:

Bernard Liengme wrote:
An untested thought: try using Paste Special | Values , if this is
appropriate to your needs
best wishes
Bernard thanks for the reply. I cut and pasted values only to a new
workbook. Total size....32K. So it did work. But if I do a copy of
visible lines only on a subtotal sheet does that not get rid of the
underlying data?

It was like Excel still thought that all 70,000 lines
were still on the worksheet.

gls858