Using Export Wizard several tables are used to export into different Excel worksheets in an XLSX file. This file was then saved as an XLSM Excel Macro file. Export Template file was then modified to point each table output to a different worksheet in XLSM file. Export does not export data into correct worksheet in XLSM file.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for SQL Server. Issue is fixed in Toad 5.8 Beta release available at: http://toadforsqlserver.com/beta.jspa
