Removing macros to make file smaller

I am working on a file with several sheets (around 70). In a previous version of this file, I recorded a macro to export some of the sheets and value the numbers. This made the file size balloon to 54 MB!! Even after deleting the macros it would not make a difference.

I subsequently redid the file, copying just the data over to sheets in the new file. There are no macros in this new file. I checked the size and it showed as 6.5MB. Awesome. But when I went out of Excel and wanted to send it the size is 15 MB!

Why does this happen? How can I remove this macro bug that is expanding my file to such a degree?

Please help!!

This generally happens when you are copying and pasting all the cells in a worksheet. Without seeing your code it's difficult to comment, but copy and pasting should be kept to a minimum and excluded altogether wherever possible.

It is extremely unlikely that a few lines of text (read macro) can balloon your excel file.

Thanks David! I have downloaded it now, but how do I actually run (use) it in Excel?

Yup, that is exactly what I have been doing. But certainly it cannot be efficient to retype all formulas and redo all formatting for sheets that contain the same data?

If you need to do that, just copy and paste the ranges you need - not ALL the cells in the sheet

Hi guys,
Thanks so much for all the input. I have established that it is not the macro, it is actually my rogue copying and pasting. Will try to do it in another way.

Glad you got it sorted, thanks for the feedback