"Not Enough System Resources" with Controls on Zoomed Sheets

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q183503

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

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Back to the top

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.

Back to the top

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.

Back to the top

APPLIES TO

Microsoft Excel 97 Standard Edition
Microsoft Excel 95 Standard Edition
Microsoft Excel 95a
Microsoft Excel 5.0c

Back to the top

kbbug kbpending kbui KB183503

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top