Forum Discussion
Computational intense Excel file (no code), need to run in cloud - Options?
Yes, hardware is quite good. Not sure if more powerful hardware will help, i'd try to optimize the file first.
You may try to convert it in binary format (save with .xlsb extension), that shall reduce the file size and improve the perfrmance somehow.
Don't know Mac version, on PC Pro version there is the option Clean Excess Cell Formatting (it affects only cells without values), sometimes it reduces the size and improve performance significantly, especially for files what exist with lot of changes for years.
New find. Excel for Mac will only use one processor to calculate. No option for multi-core support on the Mac. Microsoft really sucks. Especialy considering I have a machine with 8 cores ready to be used if needed. Tested on a Windows machine and it is no faster minus the calculation part. Waiting 60 seconds for a result doesn't bother me. Waiting 12 - 18 hours for formulas to copy over does bother me.
I saved to xlsb format and it increased the file size (xls) and 617 MB (xlsb). Yikes!
I had to increase the cells making calcs and now the spreadsheet is at ~480 MB. Copy cell formulas to the new cells took over 12 hours of operation by the computer.