Forum Discussion
Excel file wrong format
Im getting this message when i try to open my excel spreadsheet. "Excel cannot open the file because the file format or file extension is not valid."
Please help, was sent here from a representative who was not able to figure out a solution.
1 Reply
To view or edit in Office for the web, use the following table to check which file formats are supported.
Unable to View or Edit Office files by using Office Online or Office Web Apps
Microsoft Excel
File formatView in Excel for the web or Excel Web AppEdit in Excel for the web or Excel Web App
Open XML (.xlsx)
Yes
Yes
Binary (.xlsb)
Yes
Yes
Binary (.xls)
Yes on OneDrive
Not on SharePointYes on OneDrive.
Not on SharePoint.Macro (.xlsm)
Yes
Yes. However, you are prompted to create a copy of the file that has the macros removed when you save the changes that you have made.
Other file formats (.xltx, .xltm, .xlam, .xlm, .xla, .xlt, .xml, .xll, .xlw,ods, .prn, .txt, .csv, .mdb, .mde, .accdb, .accde, .dbc, .igy, .dqy, .rqy, .oqy, .cub, .uxdc, .dbf, .slk, .dif, .xlk, .bak, .xlb)
No
No
Additional Information:
Free Excel for the web templates on Office.com
Differences between using a workbook in the browser and in Excel
Hope this information was helpful to you.
I know I don't know anything (Socrates)
