I'd like to set the output encoding of exported XML data from Excel 2010
===

I have done some research for some hours now and can't even find a hint for a working solution.
The used and needed character set in the xml-mapped xlsx file is ISO-8859-1, but everything just exports as utf-8, which is just not user friendly for our content.
The web encoding setting seems to be getting ignored.
WHen setting the encoding in the xml itself and importing the data into the file the import fails.
Any ideas appreciated.
Thanks