Yep, the macro is the best way of cleaning the file, but it was the 1m rows of formatting on the emails sheet from 113 to the bottom. Delete all that an you are down to 335.

Give it a try and let us know if it works.

(if it does delete the file so no one else can download)