Introduction
Connect
Create ODBC Connections
Create Oracle Connections
Create Snowflake Connections
Create SQL Server Connections
Create SharePoint Connections
Understand Toad Connections
Troubleshoot SQL Server Connections
Understand
Determine the Best Method to Locate Objects
Object Explorer
Filter Databases and Objects
Understand a Table Using the Database Explorer
Search for Objects
Create an Database Diagram to Use as a Query Template
Browse Data in Related Tables
Query
Tutorial: Build a Query Visually
Create Cross-Connection Queries
Reverse Engineer Queries
Build a Subquery
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Report
Automate
Open Reports in Excel
Excel files open and display in two different ways in Toad: in a Toad document window or in an instance of Excel, depending on what module or tool you use to open the file.
To open an Excel file using the File menu
| » | Click  in the File toolbar and select an Excel file. |
The file opens in a Toad document window.
Notes: If more than one Excel file is open in a Toad document window at one time, the Excel toolbar is disabled for the additional files. See Troubleshoot Excel® Issues for more information about issues with Excel file menus.
| Module used to open Excel file | File opens in |
|---|---|
| File | Open File | Toad document window |
| Project Manager | Instance of Excel |
| Reports Manager | Instance of Excel |
| Toad Web Browser | Instance of Excel |
| Connection Properties dialog, Open in Excel link | Instance of Excel |