Forum Discussion
Simultaneous editing and saving of Excel files with integrated macros (Visual Basic) in Teams
Hello Andrew Hodges ,
thanks for your response.
We open the file in the excel destop version. So we can work with visual basic and use the macros. When several people are working in the excel file in the destop version of excel, it is not possible to upload all changes of the different poeple to the Share Point. Unfortunately some users got the message of "upload failed". So their changes got lost or they had to save to file as a copy.
We want to work in the same file and save the changes of all people in the same file on Sharepoint, without any changes being overwritten or deleted. We are currently trying this without automatical saves in excel.
Is this possible with Microsoft Teams / Sharepoint? If it is, how?
Hi hallo1234 ,
There are some things that will affect excel editing:-
1. Quick Win10 laptops - I would hope you are on Win10 but if you are still on Win7 forget being able to use co-authoring, the laptops cannot handle it, under 4GB of memory is not enough to run latest version of Office.
2. Latest version of Office - if you have older versions you will notice co-authoring not working as much as in the later versions.
3. Internet connection - if it is bad this will stop real time updates getting back to the spreadsheets and you will start getting the upload failed.
4. Single Sign on - a must for co-authoring - if you don't remain signed in uploads will fail.
Having said all that,
From experience co-authoring only works until it doesn't, what I am saying is the more complex spreadsheets will hit a point where it just doesnt work no matter what you do to try and fix it. You just have to find another solution in those scenarios.