I can open xls and xlsx formats in Calc but can’t save back to Excel. ANY Excel-compatible format I try in LO 126.96.36.199 generates this message: "This document may contain formatting or content that cannot be saved in the currently selected file format “Microsoft Excel 97/2000/XP/2003”. A previous LO version, 188.8.131.52 insisted I was trying to save in “Microsoft Excel 2007/2010/2013 XML”.
Regardless, when I click the button to save in whatever Excel format it says I’m trying to save in, Excel subsequently objects. It attempts a repair, then opens the document in a tiny, non-resizeable window, with all the columns set to a narrow width.
I’m on OS X Snow Leopard. Excel for Mac 2011 14.4.3.
Any help would be much appreciated.