Microsoft KB Archive/183503

= "Not Enough System Resources" with Controls on Zoomed Sheets =

Article ID: 183503

Article Last Modified on 8/17/2005

-

APPLIES TO


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

-



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



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:


 * 1) Hold down the CONTROL key and click the form control to select the control.
 * 2) On the Format menu, click Control.
 * 3) 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. This problem no longer occurs in Microsoft Excel 2000.



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 XL

Keywords: kbbug kbui kbpending KB183503

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.