File size issue

[fenerian]

Hi all,

I have a workbook which runs several macros and creates a report. The file size is 700kb. But after I run the macros and save the file it becomes 15mb. When I save it as 15mb and restart the computer and resave that file it goes back to 700kb.

Is there a fix for this?

Thanks.

 

[mole999]

what do the macros do

do you ahve a macro on workbook open that clears down previous operations ?