Can Toad export to an Excel worksheet without overwriting other sheets?h (4305364)

1. Make a copy of Excel file (for backup)
2. Open the Excel file
3. Create a new worksheet and name it, or empty data that is currently in the required worksheet
4. Position the cursor in the first cell of the required worksheet
5. In Toad, run a query and use the 'Excel Instance' option when doing an 'Export Dataset'.
6. Check the option 'Start at active Cell'
7. Specify the name of the worksheet in 'Sheet Name'
8. Click 'OK' to run the Export

Note: This operation cannot be undertaken if scheduling the 'export dataset' as part of the Automation Designer as the excel file needs to be open and the cursor positioned in the correct cell.