Forum Discussion
Eric Barger
Aug 29, 2017Copper Contributor
Computational intense Excel file (no code), need to run in cloud - Options?
I have a computational Excel file. It is on one worksheet and has no code. It is simple math but a lot of it. I need to run it on something more powerful than my 4.2GHz quad core SSD latest model iMa...
SergeiBaklan
Aug 29, 2017Diamond Contributor
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.
Eric Barger
Aug 29, 2017Copper Contributor
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?