Excel closing all open files when trying to open another file from Sharepoint/Teams

Question

Hello everyone,

We are currently experiencing a Problem with Excel/Teams. On multiple occasions now, Excel has closed all open Sheets without saving them, after the User tried to open another excel sheet stored in a Teams Channel. The Files that were closed are stored on the local machine, which is a remote Desktop running Windows 8. Auto-Save was not enabled for the ''locally'' stored sheets. The Number of sheets open and the sheet on Teams they were trying to open was different on all occasions

We have just recently started using Microsoft Teams/Sharepoint, so our experience with troubleshooting is very limited.

Thank you in advance.

Answer 1

Hi,

Note- Please backup your files before implementing any of these steps...

Here are a few things you can do-

• Ensure that both Excel and Microsoft Teams are up to date with the latest versions.
• Clear the Excel cache by following these steps:
  • Close all instances of Excel.
  • Press Windows Key + R to open the Run dialog box.
  • Type %temp% and press Enter. This will open the temporary folder.
  • Select all files and folders in the temporary folder and delete them.
  • Restart Excel and try opening the files from Teams again.
• Use the Microsoft Office Repair feature to repair any potential issues with the Office installation.

1. Ensure that the user accessing the files has the necessary permissions both in Teams/SharePoint and on the local machine. Make sure they have appropriate read/write access to the files and folders.

Best Regards.