Cannot save as xlsx

Question

I mentioned I had crashes with Excel ; now I have files both with xls and xlsx suffix. Those with xls give some warning message that certain features or structures will be lost when saving

I tried the Save As... command but there is no xlsx option

I have seen the same problem mentioned here on the Forum. I restarted my Mac and also reset the custom bar, but the xlsx option does not reappear.

Answer 1

If it's a .xls to begin with, that's what Save As defaults to, but... Look at the very top of the list of file formats - above the spot where you actually click to open the list. IMO a poor UI design flaw, but you'll see Excel Workbook (.xlsx) listed above everything else - but it seems to be lost among the file names.

There is always a warning that something may be lost if you attempt to save in something other than .xlsx or .xlsm format, but it doesn't necessarily mean that anything actually will be lost. For example, .xls only supports 256 columns by 65,536 rows, but when you open one in Excel 2007/2008/20010/2011 the sheets are provided with the full complement of 16,384 columns by 1,048,576 rows. If you continue to save in the .xls format those additional columns & rows cannot be retained so any content in that portion of a sheet would be lost.

Regards,

Bob J.

Answer 2

There is no xlsx; the default is xls.

There is also a warning for compatibility

Answer 3

This is the first option in the save as dialog. You do not need to scroll into the list it is the default, called "Excel Workbook."

What do you see in the save as dialog as the first entry (unclicked dropdown) for format?