Microsoft 365 / Sharepoint inherently slow?

[bazzinga]

Good Morning,

Just curious if anyone have experience or knowledge about using Excel in Sharepoint. It is taking ages for me to populate a SUMPRODUCT formula (about 130 lines x 130 lines). On desktop it might take a few seconds, but on Sharepoint it either times-out or taking nearly a minute (to expand the formula to say...4 lines).

The excel itself is not that much, it currently contains roughly 800 lines, and roughly 130 columns (last year it total around 16k lines). People actively working on the spreadsheet (simple inputs/actions as typing letters and numbers) are roughly 3~4 people.

Is there anything that can be done to optimize the speed, or is Sharepoint very bad at updating real-time? And on that note, if anyone knows if Google Drive is any better in comparison?

 

[jkpieterse]

What does your SUMPRODUCT formula look like?
Are you editing in the bowser or with desktop Excel?

 

[bazzinga]

What does your SUMPRODUCT formula look like?
Are you editing in the bowser or with desktop Excel?

I think its as simple as it gets. Its just two columns per lines:
=SUMPRODUCT($J$4:$EB$4,J50:EB50)
=SUMPRODUCT(J50:EB50/$J$5:$EB$5)

Its taking so long to the point it disconnects(?) me from the server / times-out if I try to expand it to more than say... 8 lines, that I am considering just waiting after work do it offline (desktop) and re-upload.

Editing on Browser since there are 3 other people who actively using the Excel to input/edit information. Which is why I am wondering if its problem with Sharepoint and contemplating if switching to Google Drive would do a better job co-authoring.

 

[jkpieterse]

Hmm, odd indeed. By the way, you should be able to edit the file in both desktop and web Excel, collab should "just" work on either platform.