SOLVED
Home

Issues with Excel Docs in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-214357%22%20slang%3D%22en-US%22%3EIssues%20with%20Excel%20Docs%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-214357%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20charged%20with%20moving%20a%20bunch%20of%20shared%20spreadhseets%20from%20Google%20Docs%20to%20MS%20Teams%20and%20have%20run%20into%20a%20few%20issues.%3C%2FP%3E%3CP%3E1.%20I%20seem%20to%20be%20the%20only%20team%20Owner%20that%20can%20open%20a%20particular%20spreadsheet%20in%20Excel%20(not%20Teams%2C%20not%20the%20on-line%20version)%20without%20it%20opening%20in%20Read-Only%20Mode.%20There%20are%20no%20protections%20on%20the%20spreadsheet.%3C%2FP%3E%3CP%3E2.%20Members%20do%20not%20see%20real%20time%20updates%20from%20other%20members.%3C%2FP%3E%3CP%3E3.%20File%20gets%20locked%20when%20others%20are%20editing%2C%20or%20it%20will%20inform%20that%20the%20current%20user%20has%20it%20locked%20for%20editing.%3C%2FP%3E%3CP%3E4.%20Unable%20to%20Save%20Workbook%20errors%20that%20suggest%20downloading%20a%20copy%20(not%20a%20good%20idea).%3C%2FP%3E%3CP%3E5.%20Copy%2FPaste%20sometimes%20returns%20an%20error%20%22Retrieving%20data%2C%20wait%20a%20few%20seconds%20and%20try%20again%22%3C%2FP%3E%3CP%3EDoes%20anybody%20else%20see%20issues%20like%20these%3F%20There%20are%20a%20few%20more%20that%20I've%20received%20compaints%20about%2C%20that%20escape%20me%20at%20the%20moment%2C%20but%20people%20are%20complaining.%20%26nbsp%3BThey%20were%20happy%20with%20Google%20Docs%2C%20and%20are%20not%20happy%20with%20Teams.%20Any%20advice%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-214357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216387%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20Excel%20Docs%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216387%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20resolved%20this%20issue%20by%20updating%20from%20v%201708%20(8431.2270)%20Semi%20Annual%20Channel%20to%20v%201806%20(10228.20104)%20Monthly.%20AutoSave%20switch%20now%20accessible%2C%20and%20co%20authoring%20seems%20to%20work.%20Realtime%20updates%20from%20other%20authors%20are%20now%20visible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-214531%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20Excel%20Docs%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-214531%22%20slang%3D%22en-US%22%3E%3CP%3EAnother%20issue%20is%20%22Changes%20not%20saved.%20Couldn't%20merge%20your%20changes%20with%20someone%20elses%22.%20Very%20frustrating%20application!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Joseph Borghi
New Contributor

I have been charged with moving a bunch of shared spreadhseets from Google Docs to MS Teams and have run into a few issues.

1. I seem to be the only team Owner that can open a particular spreadsheet in Excel (not Teams, not the on-line version) without it opening in Read-Only Mode. There are no protections on the spreadsheet.

2. Members do not see real time updates from other members.

3. File gets locked when others are editing, or it will inform that the current user has it locked for editing.

4. Unable to Save Workbook errors that suggest downloading a copy (not a good idea).

5. Copy/Paste sometimes returns an error "Retrieving data, wait a few seconds and try again"

Does anybody else see issues like these? There are a few more that I've received compaints about, that escape me at the moment, but people are complaining.  They were happy with Google Docs, and are not happy with Teams. Any advice? 

 

 

 

2 Replies

Another issue is "Changes not saved. Couldn't merge your changes with someone elses". Very frustrating application!!!

Highlighted
Solution

We resolved this issue by updating from v 1708 (8431.2270) Semi Annual Channel to v 1806 (10228.20104) Monthly. AutoSave switch now accessible, and co authoring seems to work. Realtime updates from other authors are now visible.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies