Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Muktiple workbooks inExcel 2010 save as XML file

22 Mar 2011   #1

Linux CENTOS 7 / various Windows OS'es and servers
Multiple workbooks in Excel 2010 to be saved as an XML file

Hi all

It seems not possible to save a 2010 EXCEL spreadsheet containing multiple workbooks as an XML file -- however you CAN save it as a type 2003 XMLworkbook. This works and seems to conform to the XML standard but are MS going to drop this.

XML is a decent OPEN common standard -- we use it a lot for transferring data between various systems including SAP which although has its own IDOC type of interface it also handles XML files.

(Any SAP consultants -- XML also used a lot in XI / PI data transfer too --much better than IDOCS since you avoid another whole set of conversion processes and the XI / PI data can be formatted any way you want too).

I'm perplexed in that EXCEL 2010 is prompting for a format that is AT LEAST 2 releases of EXCEL earlier.

Are we suddenly going to lose XML support.

Showstopper if this DOES happen.


Attached Images
Muktiple workbooks inExcel 2010 save as XML file-excel.png 
My System SpecsSystem Spec
23 Mar 2011   #2

Windows 7 Home Premium 64bit

I am not altogether familiar with this subject, but I wondered if the following links might of some use:

Welcome to the Open XML SDK 2.0 for Microsoft Office

Merging Data from Multiple Workbooks into a Summary Workbook in Excel 2010
My System SpecsSystem Spec

 Muktiple workbooks inExcel 2010 save as XML file

Thread Tools

Similar help and support threads
Thread Forum
Excel Warnings - Links to Other Workbooks
I have an Excel Workbook that I use for tracking expenditures and month-end bank balances, so I update it frequently. I create a new workbook for that purpose with each new year. I've tried doing this a number of different ways but I keep ending up with the same erroneous message when I open the...
Microsoft Office
My problem with unsaved workbooks in Excel
Hello to all, I have few problems or misunderstandings about the auto-saving/recovering workbooks in Excel 2010 that try to explain them clearly as follows: First I create a New Microsoft Excel file And put some data into it and wait for more than 1 minute, because I changed the time of Save...
Microsoft Office
how do i modify sidebar word 2010 save as save in
how do i modify sidebar word 2010 save as save in ? i am running window 7 thank you
Microsoft Office
Residual File Names in Save/Save As Dialog Boxes
With regard to clearing lists of file names in Windows file dialog boxes, Orbital Shark had described the following procedure (from his 01 Nov., '10 post-) : "If you want to selectively clear the Common Dialog file...
General Discussion
File load and file save menus take a long time to appear
A month or two ago I started noticing that when I try to save files to HDD from Opera it takes about 4 seconds for the (explorer) file menu to appear and let me save it. Now I noticed the same in Subtitle Workshop and Irfanview, only that in these it takes even longer, like 7 seconds, for the...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 06:50.
Twitter Facebook Google+