Signed up to chime in. I have had this issue and have a resolution that has worked for me.
Context: When exporting from MS access to excel I would get 'table is not in the expected format'. In my scenario I did not export to linked tables. I delete and re-write fresh spreadsheets each time. In...