Toad for SAP Solutions 4.2 - Installation Guide

Chat now with support

Review the following to help troubleshoot and solve issues involving Excel files.

Working with Excel Files

Issue	Cause/Solution
Microsoft Excel worksheet row and column limits	When exporting to Excel, be aware that Excel worksheets have limits for maximum number of rows and columns supported. See Microsoft Excel specifications and limits for more information.

Issue

Cause/Solution

Microsoft Excel worksheet row and column limits

When exporting to Excel, be aware that Excel worksheets have limits for maximum number of rows and columns supported.

Issue	Cause/Solution
Excel menus do not display when you open Excel files in a Toad document window.	The Toad document window cannot display all Excel menus. Solution: Right-click the Excel toolbar and add the equivalent toolbar for the missing menu or functionality.
When two or more instances of Excel are open in Toad document windows, toolbars are active for only one instance.	Toad document windows support one Excel instance at a time. Opening more than one Excel file disables the Excel toolbars for the additional files. Solution: Open only one Excel file at a time.

Issue

Cause/Solution

Excel menus do not display when you open Excel files in a Toad document window.

The Toad document window cannot display all Excel menus.

Solution:

Right-click the Excel toolbar and add the equivalent toolbar for the missing menu or functionality.

When two or more instances of Excel are open in Toad document windows, toolbars are active for only one instance.

Toad document windows support one Excel instance at a time. Opening more than one Excel file disables the Excel toolbars for the additional files.

Solution:

Open only one Excel file at a time.