# TDP exporting to a specific sheet within an Excel Workbook Using automation **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [April 29, 2015, 12:11pm UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201 "2015-04-29T12:11:36Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![gregory.young\_453](https://avatars.discourse-cdn.com/v4/letter/g/9d8465/32.png) [@gregory.young\_453](https://forums.toadworld.com/u/gregory.young_453)\ **Post date:** [April 29, 2015, 12:11pm UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/1 "2015-04-29T12:11:36Z")
I am attempting to build an automated report that updates a specific worksheet in Excel on a daily basis. All the while maintaining the other existing worksheets. I have followed Debbie’s article _ **Automate Complex Excel Reports** _ at [http://dev.toadfordataanalyst.com/webhelp/Content/Automation/Tutorials/Automate\_Complex\_Excel\_Reports.htm](http://dev.toadfordataanalyst.com/webhelp/Content/Automation/Tutorials/Automate_Complex_Excel_Reports.htm) I have successfully managed to get the export to work; however, during the process my remaining worksheets are lost. I was under the impression that this was possible to do with TDP 3.6. Can anyone perhaps provide some insight on how to accomplish this? Greg ---
**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\ **Post date:** [May 1, 2015, 9:28am UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/2 "2015-05-01T09:28:44Z")
Make sure you unchecked the overwrite box (see screen shot attached). ![screenShot.jpeg](https://global.discourse-cdn.com/quest/original/2X/6/63380b9f51c54791fd91b277a1ca9263d6917807.jpeg) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [May 6, 2015, 6:14pm UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/3 "2015-05-06T18:14:37Z")
Did unchecking the overwrite option resolve? ---
**Author:** ![gregory.young\_453](https://avatars.discourse-cdn.com/v4/letter/g/9d8465/32.png) [@gregory.young\_453](https://forums.toadworld.com/u/gregory.young_453)\ **Post date:** [May 12, 2015, 10:29am UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/4 "2015-05-12T10:29:26Z")
Yes, I verified that I had unchecked the overwrite. Still not working as expected. Thanks ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [May 12, 2015, 5:10pm UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/5 "2015-05-12T17:10:07Z")
Looks like you ran into a bug. When you add the date suffix to the file it does not use the original file. I entered QAT-5683 to fix in TDP 3.8. For now take the suffix off. You can use the Copy file to add the suffix. Or you can use the Export Wizard activity. This does the same thing but does not have the error. ![Suffix Issue.png](https://global.discourse-cdn.com/quest/original/2X/0/00d36d71a0f96cdcccd307f813455bdecec963d4.png) ---
**Author:** ![gregory.young\_453](https://avatars.discourse-cdn.com/v4/letter/g/9d8465/32.png) [@gregory.young\_453](https://forums.toadworld.com/u/gregory.young_453)\ **Post date:** [November 18, 2015, 10:37am UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/6 "2015-11-18T10:37:02Z")
I thought this was resolved. Still seeing the same issue. Have I perhaps missed the release of TDP 3.8? Please advise. ---
**Author:** ![GregDavis11009](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gregdavis11009/32/122_2.png) [@GregDavis11009](https://forums.toadworld.com/u/GregDavis11009)\ **Post date:** [November 18, 2015, 12:13pm UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/7 "2015-11-18T12:13:02Z")
Greg, you need to do this in two steps. 1. update the base file (do not change the name with a date suffix). 2. after the export is done and the base file has been updated. Then copy the file to a new name with the date suffix. The only thing that should change on the base file is the last updated date, don’t change the file name of the base file, ever. A non-existant file name logically means you are creating a new file not updating an existing one. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [November 18, 2015, 6:28pm UTC](https://forums.toadworld.com/t/tdp-exporting-to-a-specific-sheet-within-an-excel-workbook-using-automation/33201/8 "2015-11-18T18:28:11Z")
QAT-5683 is marked fixed for TDP 3.8. This version is due to be released Dec 2. Did you try the Beta? [www.toadworld.com/…/](http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program/)