Forum Discussion
Simultaneous editing and saving of Excel files with integrated macros (Visual Basic) in Teams
We tried to work in the same excel file with integrated macros (visual basic), which is stored at the SharePoint. While a few people were working with the file, some got the automatical message: "Error during upload". Is it possible to work in teams and combine and save all changes of the file in Teams, while several people are working with the file? We tried to save at the same time and sometimes changes of some people got lost and couldn't be uploaded in Teams (in the cloud).
Hi hallo1234 ,
This is all to do with the functionality of Excel Online which does not have the full functionality of the desktop version. The answer to your question is yes, but not in all situations. Having Macros is one situation where co-authoring doesnt work correctly, usually if the functionality is completely not compatible you won't be able to open the file, strange you can with the macros enable to be honest.
The other situation where co-authoring just doesnt work is with very large spreadsheets. We have found that because of the size of the spreadsheet we have had to find alternatives.
Alternatives are:-
1. Turn off co-authoring by requiring checkout/in.
2. Convert the spreadsheet to a SharePoint list which is much better suited to per row editing.
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.
