On 27/11/13 15:37, Bev Nicolson wrote:
{I Wrote} I don't quite know how you ended up with an XML file though!
Er, by assuming Excel 2003 was a shareable option... (Shows as a text/xml option if that answers Mark's question.) If I need to use Calc again, I shall be more careful.
Well blow me down. Calc does indeed list XML as an Excel 2003 option. Very near to Excel 2003 XLS.
I'd always use XLS for spreadsheets and DOC for word. What I've done is set the defaults as follows:
On the menus: Tools Options Expand Load/Save General Document Type =choose spreadsheet Always Save as=Microsoft Excel 97/2000/XP/2003
I'd also change Document Type=Text Document Always Save as=Microsoft Word 97/2000/XP/2003
Then press OK. Hope that helps. Steve