Can anyone tell me what the fix is for this error?
The file is not in the expected Excel format. Only Excel 97 and higher versions are supported. Failed: DwchServer.ExporterFailureException: Exporter method RunAllExports returned false.
I had this problem too. If you go into the export tab and you go to the "type" area, check the overide box, and set the export to V8 rather than V9. It fixes that error for me.
Retrieving data ...