File size after runnign macro

All,

I have a series of macros that format an excel spreadsheet and produces a overview page of the results. Nothing too fancy at all.

However when the macro runs the file size grows from 500 kb to around 7Mb.

Has anyone else seen this and how did you overcome it

thanks

Richard

I had something similar quite a while ago but it was on a network drive, some unkind folk had made local copies of my workbook (but didnt break any links created) so when my code ran to gather in formation it tried to make copies for all other workbooks...............i found the culprits pulled their arms outta their sockets and beat them with the sticky ends then all seemed fine!

Give it a go it's a satisfying feeling! haha!

seriously i would look for links to other worksheets or books or maybe in your code you are calling a procedure that has a call for a procedure that calls back to it...........if that made sense!

Regards,
Simon

Thanks alot will have a look.

Sadly but neither of these were the case.

Any other ideas anyone?

I could be clutching at straws but try turning off Track Changed in Tools Options.

regards,
Simon....

You could mail the workbook to me if you wish and i will have a look, if you would like mail to SimonwlloydATmsnDOTcom

Sadly but neither of these were the case.

Any other ideas anyone?

Simon your a genius!

Cheers a million for all of your help.

My worksheet is now perfect!

File size reduced from 18mb to less than a mb.

thanks again for all your help Simon and just hope can be of assistance to you one day