The issue you are experiencing with opening the Excel file in SharePoint, despite having edit permissions, could be due to several factors. Here are some potential causes and solutions:
- File Path or Name Issues: Ensure that the file name and path are correct. Sometimes, special characters in the file name or path can cause issues.
- File in Use: Although you mentioned that no other Excel files were open, it's possible that the file is being accessed by another user or program. Check if the file is locked or in use by someone else.
- Corrupted File: The file itself may be corrupted. Try downloading the file to your local machine and see if it opens correctly in Excel. If it does not, you may need to restore a previous version of the file from SharePoint.
- Office Document Cache: Clearing the Office document cache can sometimes resolve issues with opening files. You can find instructions on how to delete the Office document cache in the Microsoft support documentation.
- Permissions: Even though you have edit permissions, ensure that there are no additional restrictions set on the file or library that may prevent access.
- Antivirus or Security Software: Sometimes, antivirus programs can interfere with file access. Check your antivirus settings to see if it is blocking access to the file.
If these steps do not resolve the issue, consider reaching out to your IT support for further assistance, as they may have more specific tools to diagnose the problem.
References: