I am trying to export data to Excel 2010, but it will not allow me to do so.
Upgrade your version of Toad for Data Analysts to a version that supports Excel 2010. The first version of TDA to support Excel 2010 was version 2.7. Please upgrade your version of TDA and let me know if you still have a problem. Here is a link to where you can download the latest version.
https://support.quest.com/softwaredownloads.aspx?pr=268444401&syn=Toad+Data+Analysis
Note: Toad for Data Analysts has been renamed to Toad Data Point, starting in version 3.2. Toad Data Point is not longer free with Toad for Oracle. You have to have a Toad for Data Analysts or Toad Data Point license key in order to use Toad Data Point. However, you are still able to download versions of TDA prior to v3.2 and use those free with a Toad for Oracle key.