VBA: Size of .xlsm file too large help with reducing

[BIGTONE559]

i have a .xlsm file that is extremely large. My workbook has a data connection to two query tables in access. My question is what methods could i look into for reducing the size of the file?

 

[n0gel]

You could try saving it as an .xlsb file. I'm finding they are smaller, faster files, and macro enabled.

 

[BIGTONE559]

You could try saving it as an .xlsb file. I'm finding they are smaller, faster files, and macro enabled.

I saved a test doc as an .xlsb and for some reason or another it would not allow me to run macros. . it says something to the extent that macro security won't allow me?!?!?!

 

[n0gel]

Make sure you have macro security set to low or medium. If you were running macros from your xlsm file then you shouldn't need to do this, though. So what was the file size reduced to when saved as an xlsb file?

edit:
(Click the Microsoft Office Button , and then click Excel Options.
In the Trust Center category, click Trust Center Settings,
and then click the Macro Settings category. In the Macro
Settings category, under Macro Settings, click the option
that you want.)

 

[BIGTONE559]

Make sure you have macro security set to low or medium. If you were running macros from your xlsm file then you shouldn't need to do this, though. So what was the file size reduced to when saved as an xlsb file?

edit:
(Click the Microsoft Office Button , and then click Excel Options.
In the Trust Center category, click Trust Center Settings,
and then click the Macro Settings category. In the Macro
Settings category, under Macro Settings, click the option
that you want.)

I was already running macros within the file when i saved it as an xlsb. I did notice a significant size reduction in one of the files. It went from 11.5 MB to 3.5 MB. So i appreciate the information regarding this file type. I have a test folder i use to test docs and it may not have been in the list of trusted locations. As soon as i get to the office i'm going to check into that.

 

[n0gel]

That's consistant with my experience. I don't have any use for the other file types, escpecially the xlsx. But both xlsx & xlsm files types were created largely to be open office doc compliant, I think. I'll probably hear the truth after saying that. But whatever, I just don't hang out with open office type people.