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