Jazzy_Fizzel
New Member
- Joined
- Apr 4, 2018
- Messages
- 1
Hi,
My question is more theoretical. We have a file that requires the use of complex formula for a large set of data. The XLS version of the file is much faster than the XLSX or XLSM version. I understand why the XLS file is faster and explain it to one of the managers. Whoever the manager insists on using either the XLSM or XLSX version as the XLS is older. I offered the solution to turn automatic calculation which was also refused. My last resort is to find reliable sources or MS documentation that can officially confirm that XLS file are indeed faster. I searched the web to find a bunch of articles and forums, but none seems reliable source to my manager. I was wondering if anyone knows where I can find reliable text or article that can validate the performance of these three types of files?
Thanks in advance.
My question is more theoretical. We have a file that requires the use of complex formula for a large set of data. The XLS version of the file is much faster than the XLSX or XLSM version. I understand why the XLS file is faster and explain it to one of the managers. Whoever the manager insists on using either the XLSM or XLSX version as the XLS is older. I offered the solution to turn automatic calculation which was also refused. My last resort is to find reliable sources or MS documentation that can officially confirm that XLS file are indeed faster. I searched the web to find a bunch of articles and forums, but none seems reliable source to my manager. I was wondering if anyone knows where I can find reliable text or article that can validate the performance of these three types of files?
Thanks in advance.