Unmanageable Filesize

[robWhitz]

I have created a macro to tabulate raw data in Excel.
However, I'm pretty puzzled by 1 thing. How is it that the filesize grew to such a tremendous size, approximately 20MB, after executing the macro?

If I were to tabulate the data manually, the filesize does not exceed more than 200kb.

Is there anything I can do to reduce the filesize after executing the marco?

Please advise. Cheers...

 

[robWhitz]

Hi,

Just realise that 1 of the worksheet contains lot of redundant data. This causes the usually huge file size.

Once removed, the file size shrunk to an acceptable size.

Cheers....