XL: "Not Enough System Resources" with Controls on Zoomed Sheets

ID: Q183503

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel for Windows, version 5.0c

SYMPTOMS

If you click the following items in a worksheet multiple times or if you move a vertical toolbar over a worksheet with any of the following items

list box

drop-down list box (Microsoft Excel versions 5.0 or 7.0 only)

combo box (Microsoft Excel 97 only)

the following message may appear:

Not enough system resources to display completely

CAUSE

This problem may occur when the following conditions are true.

The Input range of the control is linked to a second worksheet.

-and-

You zoom both worksheets to percentages other than 100 percent.

-and-

The zoom percentage of the two sheets are not equal.

-and-

You move a toolbar over the control, click the control and choose values, or you alternately select each of the two worksheets.

NOTE: Sometimes an action does not result in the message, but repeated actions do. The message only occurs when the worksheet that contains the control is active.

WORKAROUND

To work around this problem, do any of the following:

Change the zoom setting of either worksheet to 100 percent. Click Zoom on the View menu, click 100% and click OK.

-or-

Change the zoom setting of both sheets to the same percentage. Click Zoom on the View menu to make this change.

-or-

Select an input range that is on the sheet with the list box, drop-down list box, or combo box.

Changing the Input Range of a Control

To change the input range of a control, follow these steps:

Hold down the CONTROL key and click the form control to select the control.

On the Format menu, click Control.

Click the Control tab and type a range on the active worksheet.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

Microsoft Excel 97

For more information about list boxes, combo boxes and input ranges, click Contents And Index on the Help menu, click the Index tab in Excel Help, type the following text


   list boxes

and then double-click the selected text to go to the "About control properties for list boxes and combo boxes" topic. If you are unable to find the information you need, ask the Office Assistant.

Microsoft Excel Version 7.0

For more information about list boxes, combo boxes, and input ranges, click Microsoft Excel Help Topics on the Help menu, click the Index tab in Excel Help, type the following text


   list boxes, linking to cell data

and then double-click the selected text to go to the "Linking controls to a cell or range" topic.

Additional query words: XL97


Keywords          : kbui kbdta xlui xldraw xlgpf 
Version           : WINDOWS:5.0c,7.0,7.0a,97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 14, 1999