Forum Discussion
Adam Valente
Nov 08, 2018Copper Contributor
SharePoint - Excel Collaboration - Read Only - Filters
Our business has like many a need to collaborate within Excel. Like many, the option to use a shared spreadsheet over a network immediately runs into performance issues in practice so that's not an ...
Adam Valente
Nov 12, 2018Copper Contributor
Hi Doug,
Thanks for your response. My problem with performance is within excel and local files with the sharing turned on. Historically it's always been the same; you get more than 2 users in the sheet at any one time and the whole thing grinds to a painful halt. Complexity; not very. Pretty basic in terms of excel features with a filter, several columns, but the file size is about 35mb.
We are trying SharePoint for this but like I say the 'live' edits make it chaotic when the filter or sort is used. To say to the 81 users you cannot use these features isn't an option.
I'll take a look at the modern/classic lists and see how they work for me. Thanks for the advice.
Stephanie_Hung
Feb 21, 2019Copper Contributor
Is there any solution to this yet? I have the same issue.