Hi PhuongMPhuongM said:Try to save the workbook to .*xlsb instead of xlsm to see if there is any improvement?
Thanks for the suggestion -I tried it. Converted the same file to xlsb and recompiled.Xlsb file 10 seconds…Exe compiled file the same 1 min 5 seconds so there was no difference on the exe -xlsm and xlsb is slow after compile. Confirmed
Windows 7 32 bit
Office 2007 Enterprise Edition
Last edited: