Hello All-
I have a large excel workbook that runs off one data sheet. Each worksheet refers back to this sheet to build graphs, pivot tables etc. In the past I have used transfer spreadsheet and it has simply overwrittem the worksheet:
DoCmd.TransferSpreadsheet acExport...