Forum Discussion

Copper Contributor

Nov 08, 2018

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 ...

Copper Contributor

Nov 12, 2018

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.

Doug Allen

Iron Contributor

Nov 12, 2018

Hey Adam,

Sounds good. That's why I was asking if it was complex because if it was, then you likely wouldn't be able to convert to a list. Remember what you could also do is use the list for data entry, sort filter etc, then if you need complexity open the list with Excel as a datasource to do pivottables or reporting.