Open Excel 2003 XML files (XMLSS) in Excel 2000

I need to open Excel 2003 XML files (not Open XML from 2007) in Excel 2000. Is there any plugin that would allow me to do this?

Edit: the name of the format is called XMLSS - XML Spreadsheet

ScottR

Posted 2011-02-25T16:24:43.287

Reputation: 111

Answers

This cannot be done unfortunately. You would need to create your own plugin.

ScottR

Posted 2011-02-25T16:24:43.287

Reputation: 111

If your Excel 2000 is fully updated with available patches, it should have no problems opening XML files generated by Excel 2003.

BBlake

Posted 2011-02-25T16:24:43.287

Reputation: 5 120

Have you tried this (I don't have 2000)? And are you referring to the Office 2003 format and not just a generic XML export data file?

– ScottR – 2011-02-25T18:09:15.797

I haven't had 2000 in years, so perhaps I am mis-remembering. But as I recall, in the Open File dialog, there was an option to select XML files to open in the file filter dropdown. Of course, as a developer, I would be tempted to tell anyone still using Office 2000 that they are out of luck. – BBlake – 2011-02-25T20:23:30.727

Okay, got my hands on 2000 - and it doesn't work. I don't think this can be done with any current plugins/updates. – ScottR – 2011-03-02T00:36:15.907

Ah, I must have been thinking of the OpenXML type docs. Apologies. – BBlake – 2011-03-03T12:57:09.457

The Microsoft Office Compatibility Pack should grant you the ability you seek.

Xantec

Posted 2011-02-25T16:24:43.287

Reputation: 2 303

That pack is for Open XML from Office 2007+ if you look at the link. I need it to open the Excel 2003 XML format.

– ScottR – 2011-02-27T23:52:22.780