Ask Your Question

Unable to open spreadsheet saved in Calc as Microsoft XML [closed]

asked 2013-08-27 16:21:45 +0100

RobertShelton gravatar image

updated 2015-11-07 11:01:55 +0100

Alex Kemp gravatar image

I created a new spreadsheet in Calc w about 6 tabs and a half dozen columns per sheet - a skeleton basically. On Save, I got the options to save in LO or Microsoft XML format. As colleagues would have to use MS Excel, I selected MS XML format. When I open the file in either Excel 2010 or LO 4.1, I get an XML import dialogue and the resulting "spreadsheet" has one tab with a bunch of XML in it. Why is LO 4.1 saving as a format that it cannot read - and that Excel also cannot read?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 11:02:07.138256

1 Answer

Sort by » oldest newest most voted

answered 2013-08-27 21:13:21 +0100

David gravatar image

I've got LibO on this machine. The options I get for Excel are as follows:

Calc save dialog

My hunch is that you've saved to "Microsoft Excel 2003 XML" which has an .xml filetype. Could you confirm the full file name of your exported file? If you save it with the "Microsoft Excel 2007/2010 XML" option resulting in a .xlsx filetype, I think you'll be good to go. (Hopefully! ;)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-27 16:21:45 +0100

Seen: 1,115 times

Last updated: Aug 27 '13