Forum Discussion
Computational intense Excel file (no code), need to run in cloud - Options?
Hi Eric,
That's 10MB limit for usual subscription https://support.office.com/en-us/article/File-size-limits-for-workbooks-in-SharePoint-Online-9e5bc6f8-018f-415a-b890-5452687b325e, in any case 270MB is not for Excel Online.
Usually with Excel the memory size is more important than CPU speed, but 16GB shall be more than enough, 8 is okay. However, not sure about 270MB file - that shall be millions of rows. Or lot of objects inside.
Perhaps there is an option to optimize the file itself or split it on several linked ones or something like this - if possible.
I ran into the 5MB file limit. I have the latest 4.2 GHz iMac with 32 GB of ram and a SSD. Excel chokes.
Breaking this up is not an option. Is there no cloud option for this scenario?
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.
Currently, the spreadsheet is 58,667 rows x 14,101 columns. In my head, that is not really that large but I guess it is a few numbers for Excel to manipulate. I need roughly the same amount of columns as rows but it feels I am pushing Excel to it's workable limit for the moment. Total bummer.
- With that many columns, you definitely take an effeciency hit.
I bet you are already using manual calculation, but with that many cells updating, I wonder if using VBA to hold off screen updating till calculations are done would be worth it. It may even be better to do all calculations in the VBA space.
If you could get doen to using a Columnar set-up might be fastest....
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.
I will try your suggestions! The math is easy, there are a lot of cells doing math that depend on the previous cell.
I am solving a double integral in Excel and when my delta x goes from 0.01 to 0.001 things get harry.
