Darn, I thought you guys had fixed that .
Using Toad 10.1.1.8 on Windows XP , I had two workbooks open in Excel 2007. (
Just o ne instance of the Excel program.) I wanted the grid exported to workbook
1 (which only had one worksheet/tab ), but in case it got sent to the wrong
workbook I went to workbook 2 and created a new blank tab (sheet5) and left the
cursor there; then went back to workbook 1; then went to Toad and did Export
Dataset, to Excel Instance .
It created a blank Sheet2 in workbook 1; and then wrote all the data to sheet2 *
in workbook 2 *, overwriting everything that was there.
Is this a known bu g? (Known to the developer bug database, I mean – I
already know about it)
Is it fixable, or is it Excel perversity?
If you can ’ t control which workbook Excel creates the new worksheet in,
can you at least make sure the data goes to the same sheet that you just
IT Commercial Technical Services - Data Management Team
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
This e-mail message may contain privileged and/or confidential information, and
is intended to be received only by persons entitled to receive such information.
If you have received this e-mail in error, please notify the sender immediately.
Please delete it and all attachments from any servers, hard drives or any other
media. Other use of this e-mail by you is strictly prohibited.
All e-mails and attachments sent and received are subject to monitoring, reading
and archival by Monsanto, including its subsidiaries. The recipient of this
e-mail is solely responsible for checking for the presence of “Viruses” or other
“Malware”. Monsanto, along with its subsidiaries, accepts no liability for any
damage caused by any such code transmitted by or accompanying this e-mail or any