I have a report, it has some data around 1300 rows, file size is around 400k.
One column is supplier name. I splite the file by company name.

I copy the data to a worksheet("TEMP") and calculate something.
after that, I copy to a new workbook.

after the process, the file size of the report change to 27.6M
I find the reason is come from sheet TEMP.
If I delete all rows in TEMP, the file size will be changed to normal.
I am sure I have clear the data in Sheet TEMP.

actually, I can use macro to delete the rows before end sub.
but I want to know the reason and delete all row spend a lot of time.

Thanks in advance