Good Morning All,
I have an existing XLS file that is in excess of 250mb and is becoming less and less user friendly. There are over 50 pivot tables in this document that the end user still requires which now takes 10 minutes to open. If we convert this file to XLSM then everything opens quickly and the file size is reduced substantially, however the report is automated and is immediately sent to the user upon it's completetion at 6am (when the user begins his day), and therefore it is not practical for me to re-open the XLS file and re-save it as XLSM. I am using 9.1.3 and my understanding is that it can not output to XLSX, hence my question: "Is it possible to export to XLSX using a work around?".
Any help would be deeply appreciated.
Regards,
Scott