Just upgraded from TOAD 8.6 to TOAD 9.7.2 and Toad for Data Analyst; Using query builder then went to output to excel; got msg like: TOAD cannot find EXCEL, is EXCEL installed on this machine. It is installed. Looking around for a place to point the software to excel.exe; no can find. Any ideas?
We had some similar issues with earlier version of TDA (18.104.22.1683, for example). For us, the problem was that .NET framework was not installed prior to installing TDA. We were able to fix the problem by uninstalling TDA, then installing and patching .NET framework first and finally re-installing TDA. Not sure if your problem is related or not…
You need to install the PIAs (Primary Interop Assemblies). Did you do this?