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.
