Open XML Spreadsheets with Excel 2000

  • Thread starter mukherjee.aniruddh
  • Start date
M

mukherjee.aniruddh

I had a requirement where I needed to save Excel 2003 as XML spreadsheet,
modify this XML and use this Excel-ML with Office 2003. But some of our users
who are still on Office 2000 are unable to view the Excel generated.
What they could see is XML written onto the spreadsheet but not the excel
contents or formatting.

Does Excel 2000 support saving and openening Excel-XMLs?
I dont see any option in Excel 2000 which would say "Save As" XML Spreadsheet.
 
P

Pete_UK

No, XL2000 does not support this, and neither does XL2002 - it was
first implemented in XL2003.

What I did when a supplier switched to issuing XML files was to use
OpenOffice to open the file (it's a free download) and then save it
from there as a proper .xls file.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help required to change format when converted from excel to xml. 1
How to transform an Excel XMLdocument in Excel 2000 3
Turn off XML Prompt when saving Excel files in Office 2007 to 2003 0
Save Excel to XML 0
How to open XML data file? 2
Turn off XML prompt when saving Excel 2003 document 0
Turn off Office XML Excel 0
Turn off Office XML Prompt in Excel 1

Top