If Auto Save feature is not working in Excel, Word or PowerPoint, follow this guide that mentions different solutions to resolve the issue.

If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.