I have built a lookup table on sheet1 to work with test data (an actual export) on sheets 2&3. I left sheets 2 & 3 intact but deleted the data to test a new export. I export the data, "adding" to the existing files, "overwriting" the existing table. All seems well until I open the xlsx, receive an error:
Excel found unreadable content in 'filename.xlsx'. Do you want to recover the contents of the workbook? If you trust the source of this workbook, click Yes.
Open clicking Yes, the workbook[Repaired] opens and I notice instead of overwriting sheet2 I have a shiny new sheet21 with my exported data.
I have tried several variations including appending the table instead of overwrite, try xls (export informs me it will only work with Excel 97 or newer???), and a couple others I have forgotten now.
Any suggestions? Please say 'yes'.