Error opening the file for edit . Getting the below error .
Reason : File format is in .xls (<= Excel 2003) .
This is a known issue . Below is the fix .
Convert the file format from xls (<= Excel 2003) to xlsx (>= Excel 2007) .
Follow the below steps to convert the file extension
- Go to the document library for the site.
- Download the file to the desktop
- Open the excel sheet from the desktop and again save as giving the .xlsx format .
- Upload it to the Sharepoint site .