We have a long-standing issue that is manifesting itself via Teams much more frequently. I have found a ton of info online related to the opening of Excel files from Network locations, and have tried everything I can get my hands on to no avail.
Scenario: Excel Spreadsheets in the FILE folder of Teams. User has a file called May Metrics. They need to create June Metrics. So they open May Metrics and make all the changes necessary inputting the new metrics. Then they save it as JUNE METRICS.
Now when another user tries to open that file, it will say that it is corrupt, try to repair, and fail because it cannot find the file in %appdata%
At this point, the user can save the file locally, open it as expected, then upload it back to Teams. Not acceptable to the users as it adds a significant amount of time and steps to the workflow. This DID occasionally happen to the users when using a file share as well, and the same workaround was used. Copy locally, then move back. However, that workaround was a tad easier and quicker when using a file share. Not being able to drag and drop from Teams makes that more cumbersome.
It appears that if they FIRST make a copy of the MAY METRICS, rename it to JUNE METRICS and then edit the copy, it will work. That is rather confusing to me, but it does seem to be a workaround.
Solving the root problem is really what I would like to do. It just so happens that Teams makes the problem show up more frequently.
So it seems apparent that this only comes into play when a file is NOT local. Searching reveals a number of reasons for that. Many talk about turning OFF the DDE, and going to the Trust Center and UNCHECKING the three Protected View settings (all seemingly counterproductive).
I've seen the suggestions to go to Trust Center and turn off all the File Block Settings as well (again, counterproductive).
- The URL is added to the Trusted Zone.
- I tried adding the URL to Trusted Locations (including subfolders) in Excel.
- Checked the "Allow Trusted Locations on my network (which is not recommended)
- Turned off DDE
- Turned off the three Protected Views within Excel
NOTES: We can save the file locally, and it will open...but that isn't very efficient in our environment because they then have to upload it BACK to Teams (or OneDrive, or SharePoint, or Network Share) when they are done.
It seems as if we CAN open it from Excel as opposed to clicking on the file itself. Again...silly, but it does seem to work a lot of the time. You have to then go through some dialogue boxes about links to other files in locations it cannot reach, but ultimately, you can get the file open.
The files are clearly NOT CORRUPT. Maybe it has to do with the way users are making edits in some way that references a local location. I can't really tell for sure because I am not an Excel Guru.
What I do know is that the user expectation is that they should be able to click on a file and start working on it without having to jump through eleventy-billion hoops.
Has anyone else had trouble opening Excel files from Teams? I can't imagine we are the only ones considering how many people online seem to experience similar issues with Excel files in Network locations.
Lastly, the problem is happening to 2013 and 2016 users. The only real difference there appears to be that each version provides slightly different dialogue when the file opens.
I've experienced many of similar issues as you describe and a tip based on my experience with Excel is that if the files contain calculations or links to other files, you should use the Excel client instead of excel online. Therefore, when you are in the teams "Files tab", select "Open in Excel" instead of just click on the file to open it (which will open it in Excel online).