Only me again,
I have tested with the default theme and deactivating all the plugins, expect the data export and it works.
I tested the export feature whilst activating each plugin one at a time, and it seems to stop working once Buddypress is activated.
I have tried only activating buddypress with the export plugin and it fails.
Any advice as to why it would fails while buddypress is activated?
Many thanks again.