Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open an XML file into Excel
I have an Excel file that has been Saved As XML by mistake. Can I make it
open properly in excel (and then put it back to .xls again)? I've tried renaming, tried importing (Data Menu, Import XLM) all to no avail (it just brings up rubbish!). I would really appreciate some help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open an XML file into Excel
Lynn,
If the XML file was saved from Excel (as 'XML Spreadsheet (*.xml)' type) you should be able to open using 'File', 'Open' & change the 'Files of type' drop down to 'XML Files (*.xml)'. Should not require anything more complicated than that. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Lynn" wrote: I have an Excel file that has been Saved As XML by mistake. Can I make it open properly in excel (and then put it back to .xls again)? I've tried renaming, tried importing (Data Menu, Import XLM) all to no avail (it just brings up rubbish!). I would really appreciate some help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open an XML file into Excel
Hi Chris
Many thanks for responding. I have subsequently explored and it looks like the file was corrupt before it was inadvertently saved as an XML file, as I've tried again and I can open from Excel with no issues. Thanks again for responding. Lynn "Chris Marlow" wrote: Lynn, If the XML file was saved from Excel (as 'XML Spreadsheet (*.xml)' type) you should be able to open using 'File', 'Open' & change the 'Files of type' drop down to 'XML Files (*.xml)'. Should not require anything more complicated than that. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Lynn" wrote: I have an Excel file that has been Saved As XML by mistake. Can I make it open properly in excel (and then put it back to .xls again)? I've tried renaming, tried importing (Data Menu, Import XLM) all to no avail (it just brings up rubbish!). I would really appreciate some help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
Why Excel file doesn't open by double click. | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) |