Good tips but I have a question. You recommended to convert to Binary format to reduce file size. I'm working with VBA and macros in my workbook and I have already saved as Macro-enabled (.xlsm). If I converted to binary then I believe my workbook macro/vba would not work. Thoughts?
Very good question. You can use the Excel macro in an .xlsb file. It’s not part of the default Excel file extension selections, however. When selecting your Excel file containing the macro(s) to run, to the right of the File name box where it shows "Excel files (*.xlsx; *.xls, *.xlsm), click the dropdown and select “All files”, then browse to and select the .xlsb file.
![KSI - Dirty [Official Visualiser]](http://i.ytimg.com/vi/VoDh1h1dPUE/mqdefault.jpg)
Changing the file to binary completely changed the speed. Thank you so much
Fantastic, I am glad you could benefit from the video. Thanks for the note and sharing your feedback.
Good tips but I have a question. You recommended to convert to Binary format to reduce file size. I'm working with VBA and macros in my workbook and I have already saved as Macro-enabled (.xlsm). If I converted to binary then I believe my workbook macro/vba would not work. Thoughts?
Very good question. You can use the Excel macro in an .xlsb file. It’s not part of the default Excel file extension selections, however.
When selecting your Excel file containing the macro(s) to run, to the right of the File name box where it shows "Excel files (*.xlsx; *.xls, *.xlsm), click the dropdown and select “All files”, then browse to and select the .xlsb file.