Forum Discussion
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 iMac.
I would like to work on the file via the web browser. What are my options? The file is ~270 MB in size.
9 Replies
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.
