Forum Discussion
Excel for the web - Co-authoring
Hi, I have several people in my organization saying that co-authoring in Excel doesn't work well for them. Especially with very huge files and when they us filters, add or delete rows, etc. The sorting gets messed up, not responding anymore etc.
Are there any Do's and Dont's for co-authoring or recommendations when better not using co-authoring in excel?
3 Replies
- I would recommend placing the excel into a file area on teams. The document autosaves everything, multiple people can utilize and make changes to the document at the same time, and access is restricted to anyone you have invited to the teams group. Filtered content can be restricted to a temp individual view to not mess with how others are viewing the document. Best practice would be to save a draft a day, in case you ever needed to go back and restart from a different point.
- Excel doesn't work well for them. Especially with very huge files and when they us filters, add or delete rows, etc.
Do you mean too many records cause running slowly？
if so,one way as far as I know is to store data in database and query by SQL.
