Macro Enable Workbook Shared - Size increase

[nosense]

Hi there,

I have created a workbook with multiple macros as "Macro enable file type". Initially it was 5MB in size but when i shared it the size suddenly increased to 45MB. Any ideas how to fix it?

Cheers,
Stan

[galvinpaddy]

Could be one of a few things really.
How many pages are inside the workbook?

Sometimes and for seemingly unknown reasons, shared workbooks carry with them a whole manner of difficulties - so much so we've stopped using them where i work.
It could simply be a slight corruption during a save function which increases the file size, it could be conditional formatting in areas that it shoudln't be, it could be you need to find all the ranges that should be empty and actively delete/clear contents from those ranges.

Rich