I have a multiple sheet XLSX workbook within which I'd like to have the data in a particular sheet overwritten without disrupting the other sheets.
Is this possible?
In the Export Wizard, choose 'Add data to file' under When output file exists.
For Table Info, choose the table you are updating then under When output table exists, choose 'Overwrite existing table'.
Hope that works!
Retrieving data ...