Microsoft Tech Community Live:  Microsoft Teams Edition
November 09, 2021, 08:00 AM - 12:00 PM (PST)

Microsoft Teams not closing document

%3CLINGO-SUB%20id%3D%22lingo-sub-1250101%22%20slang%3D%22en-US%22%3EMicrosoft%20Teams%20not%20closing%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1250101%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI'm%20having%20a%20problem%20with%20closing%20an%20excel%20file.%20I'm%20in%20a%20group%20with%20my%20classmates%2C%20and%20the%20teacher%20has%20added%20a%20tab%20called%20excel.%20This%20is%20next%20to%20the%20tab%20called%20'files'%20When%20I%20open%20this%20tab%2C%20it%20automatically%20opens%20a%20file%20that%20has%20been%20added%20by%20my%20classmates.%20I%20can't%20seem%20to%20close%20the%20file%2C%20since%20there's%20no%20option%20given%20to%20close%20it.%20In%20the%20tab%20called%20files%20you%20can%20now%20see%20that%20I%20edited%20the%20file%2C%20which%20I%20didn't%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20solve%20this%20issue%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EAileen%20J.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1250101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1251160%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Teams%20not%20closing%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1251160%22%20slang%3D%22en-US%22%3EBecause%20office%20online%20is%20used%20to%20open%20files%20in%20teams%20sometime%20ago%20they%20made%20it%20open%20in%20edit%20mode%20by%20default%20so%20this%20can%20happen%20from%20time%20to%20time%20and%20you%20can%E2%80%99t%20really%20disable%20it.%20%3CBR%20%2F%3E%3CBR%20%2F%3EPretty%20sure%20there%20was%20a%20roadmap%20item%20or%20something%20they%20were%20working%20on%20to%20allow%20you%20to%20chose%20to%20open%20a%20document%20with%20the%20client%20app%20instead%20but%20even%20then%20with%20auto%20save%20this%20could%20also%20edit%20when%20opening%20so%20that%20would%20have%20to%20be%20disabled.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAnother%20option%20could%20be%20to%20sync%20the%20files%20to%20your%20local%20computer%20with%20the%20onedrive%20client.%20Then%20you%20can%20open%20files%20there%20using%20office%20apps%20and%20turn%20off%20auto%20save.%20There%20is%20also%20an%20option%20in%20the%20onedrive%20client%20that%20lets%20you%20open%20files%20locally%20instead%20of%20the%20cloud%20then%20upload%20the%20changes%20when%20you%20save%20the%20document%20but%20this%20can%20introduce%20file%20conflicts%20on%20heavy%20collaborated%20documents%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi!

I'm having a problem with closing an excel file. I'm in a group with my classmates, and the teacher has added a tab called excel. This is next to the tab called 'files' When I open this tab, it automatically opens a file that has been added by my classmates. I can't seem to close the file, since there's no option given to close it. In the tab called files you can now see that I edited the file, which I didn't do.

 

How can I solve this issue?

Thanks in advance,

Aileen J.

5 Replies
Because office online is used to open files in teams sometime ago they made it open in edit mode by default so this can happen from time to time and you can’t really disable it.

Pretty sure there was a roadmap item or something they were working on to allow you to chose to open a document with the client app instead but even then with auto save this could also edit when opening so that would have to be disabled.

Another option could be to sync the files to your local computer with the onedrive client. Then you can open files there using office apps and turn off auto save. There is also an option in the onedrive client that lets you open files locally instead of the cloud then upload the changes when you save the document but this can introduce file conflicts on heavy collaborated documents

@Chris Webb 

I'm afraid I seem to be having the exact same problem a year later. And if there is a 'roadmap' is that something that users of Teams can easily access?

Hi Aileen, we have the same issue here. Users complain about not being able to close Excel documents clicked in Teams tabs. Since you posted last year, maybe you found a solution?
Kind regards,
This is just something users have to get used too. The cloud is always online, always open. Files edit in real time, save in real time etc. There is no more "Close" per say. Tabs in Teams are just online web views of files with office online so it's going to edit live. This allows for co-authoring and multiple people using the document at the same time etc.

The only way to edit documents offline is to use sync, and turn off the option in the sync client to Use Office to sync files. Otherwise opening files with auto save off will lock the file and prevent others from opening etc. But you also run the risk of sync issues if you open offline and then save after making changes as others can make changes at the same time.

Anyway, bottom line is users have to get used to the new way of working on cloud documents and just moving away from documents and not having to "Save" or "Close" them. It's an adjustment but they will get used to it.
Thank you Chris for your reply.

I thought that whether a document is hosted in the cloud or on a "regular" server does not make things different: I still "open" and "close" the document, and the server allocates more physical resources when the document is "opened" than when it is not. If what you say is true, would that mean that cloud servers require much more computing resources to hosts 1'000 documents than regular servers? (you seem to say they are always "open")

Same goes with the "save" function. I cannot find a technical requirement or constraint that makes this specifically a "cloud" feature. I have seen many applications implement continuous saving without the cloud, for decades. A good example of this is Onenote. Wouldn't this contradict what you proposed?

On the other side, I also think it is not a good practice to tell users to just accept things as they are and get used to it when they notice something wrong. If a user interface shows a button labelled "close" when a document is opened, and clicking on this button does nothing, I think it is a failure from the editor, and that should be fixed.

Of course, the editor could simply remove the button, as you implied, but that would likely make users' experience even worse. Or it could make the button actually work as intended, thus letting users close a document and return to whatever they were doing before opening it.

In summary, I am not sure I can agree with your proposition :)