Issue :
Error opening the
file for edit . Getting the below error .
Reason : File format is in .xls (<= Excel 2003) .
Resolution :
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 .
