Toad Data Point 5.3 - User Guide

Chat now with support

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

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 5.3 - User Guide

Open Reports in Excel