Just recently upgraded from v19 to 2013.3. Not very happy with the export to Excel formatting at all. I now have to reformat all the exported reports as the numbers come through as text, not numbers....
Status changed:
New
to Coming Soon
Hi EdenInOz, You'll be glad to know that we'll be fixing excel export in the next release (2013.4). The numbers will come through as numbers and you'll be able to do calculations. regarding working in Excel using ODBC, you can now use the API to do the same thing. I don't want to steal their thunder, but the API guys over at http://developer.myob.com/ will soon be posting a tutorial on using the API with excel. stay tuned.