psgoldberg
New Member
- Joined
- Jul 11, 2013
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
Issue: A large workbook has ~5 concurrent users running from SharePoint/Teams on the Excel desktop app (all on 365). While most changes are simple data entry and work as expected (changes show up on other users screen within seconds), some changes cause problems. For example, when a new sheet is added and renamed, the change may take seconds to minutes to show up. In certain circumstances, the changes are only partially committed. Other more complex changes (re-alphabetizing the sheets) cause even greater havoc.
Additional details: Workbook has >300 sheets but is otherwise very unsophisticated and is around 5MB. Users all have autosave on but in testing we also did manual saves which didn't change the result that only some changes made it through. It seemed as though even though a user only did a data entry change, their version of the workbook (re: names of sheets) was retained in some fashion. The process of creating a new worksheet, renaming it, creating a table of contents and re-alphabetizing the sheets is done via macro but, for testing purposes, the adding of a worksheet was done manually with similar inconsistent results.
Question: What should I expect? Is the nature of the change too complex for the synchronization process to manage so that we just need to make sure all users are not in the file when changes are made? Is there a way to ensure a commit of the version to the SharePoint server (it seems the only real way the sheet is saved is by exiting Excel) which might help the synching process?
Thanks,
PSG
Additional details: Workbook has >300 sheets but is otherwise very unsophisticated and is around 5MB. Users all have autosave on but in testing we also did manual saves which didn't change the result that only some changes made it through. It seemed as though even though a user only did a data entry change, their version of the workbook (re: names of sheets) was retained in some fashion. The process of creating a new worksheet, renaming it, creating a table of contents and re-alphabetizing the sheets is done via macro but, for testing purposes, the adding of a worksheet was done manually with similar inconsistent results.
Question: What should I expect? Is the nature of the change too complex for the synchronization process to manage so that we just need to make sure all users are not in the file when changes are made? Is there a way to ensure a commit of the version to the SharePoint server (it seems the only real way the sheet is saved is by exiting Excel) which might help the synching process?
Thanks,
PSG
