Can I convert big XLSX file to XLSB for better performance?
Solution 1:
I use xlsb for every file I create in excel, they are small and allow macros to run, I have not found any drawbacks for using this file type.
And yes you can save a file as another file type by going to saves as and choosing the file type.
This Microsoft support page should give you all the basics in getting started with saving files in Excel. https://support.microsoft.com/en-us/office/save-your-workbook-92e4aae0-452d-497f-a470-570610ff720a