- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95, versions 7.0, 7.0a
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.
and 2>
MORE INFORMATION
================
Several factors in both Microsoft Excel and Microsoft Windows can impact the
amount of available GDI memory space at any given time. Some of the situations
described below are controlled by Microsoft Excel, while others are controlled
by Microsoft Windows.
In Microsoft Excel for Windows, version 5.0, system resources are only used for
one window of resources regardless of the number of sheets open.
Note that these methods are not shown in any particular order. Also, note that
using any (or all) of these methods does not guarantee that more GDI memory
space will be available.
To Conserve GDI Memory in Windows
---------------------------------
- Use Program Manager as your shell. Although there are many other shell
programs available, many of these are more graphics-intensive than Program
Manager and may use more GDI memory space.
1. To change your shell to Program Manager, change the "Shell=" line in the
[boot] section of the SYSTEM.INI file to read:
Shell=PROGMAN.exe
2. Restart Windows to activate the new shell.
- Run as few other Windows programs (screen savers, utilities, applications,
etc.) as possible. Other programs use varying amounts of GDI memory,
particularly some graphics-intensive screen savers and applications. To make
sure that there are no applications running besides Program Manager and
Microsoft Excel:
1. Locate the LOAD= and RUN= lines in the [windows] section of the WIN.INI
file.
2. Comment out these lines by adding a semicolon (;) at the beginning of each
line so that they read ;LOAD= and ;RUN=.
3. Restart Windows.
-or-
1. Press CTRL+ESC to bring up the task list.
2. To quit each unnecessary application, select its name from the list of
programs and choose End Task.
NOTE: Because many applications do not return all GDI memory to the system
when they are closed, this method is less efficient for conserving GDI memory
space than commenting out the LOAD= and RUN= lines in the WIN.INI file and
restarting Windows.
- Don't use third-party font packages. To disable any unnecessary font
packages, check the system.drv= line in the [boot] section of the SYSTEM.INI
file. If the line reads system.drv=system.drv, it is likely that no
third-party font packages are installed. If it does not, use the proper
method for disabling your particular font package and restart Windows.
- Reduce the number of visible icons in Program Manager. Each visible icon uses
GDI memory space. To display as few icons as possible, close program groups
when they are not in use and/or reduce the number of icons in each program
group.
- Don't use background wallpaper. Wallpaper can use a fairly large amount of
GDI memory space. To eliminate background wallpaper:
1. In Windows Control Panel, double-click the Desktop icon.
2. In the Wallpaper section, select (None) in the File box.
3. Choose OK to accept the change, and then close Control Panel.
- Use a different video driver. Some very high resolution drivers (1024x768,
1280x1024, and so on) or drivers that use more than 256 colors (32K colors,
64K colors, 16.7 million colors) use extra GDI memory space. If your video
card and monitor support it, use the standard VGA driver that ships with
Windows. To change your video driver to standard VGA:
1. Run Windows Setup by double-clicking its icon in Program Manager.
2. From the Options menu, choose Change System Settings.
3. In the Display box, select VGA or VGA (Version 3.0).
4. Choose OK to accept the change. If Setup asks for a certain disk, insert
that disk and follow the instructions on you screen.
The standard VGA driver will be installed when you restart Windows.
TO CONSERVE GDI MEMORY IN MICROSOFT EXCEL
- Reduce the complexity of any open charts. For example, removing the legend,
attached or unattached text, graphic objects (arrows, custom markers, drop
shadows, and so on) will reduce the amount of GDI memory used in the open
charts.
- Hide all visible toolbars:
1. From the Options menu, choose Toolbars.
2. Then, select the name of a visible toolbar and choose the Hide button.
3. Once all toolbars are hidden, choose Close.
- Reduce the complexity of any open worksheets. For example, removing borders,
shading, and patterns from cells reduces the amount of GDI memory used, as
does reducing the number of fonts used on the worksheets.
NOTE: Point sizes and faces take up additional memory. For example, Arial 10,
Arial bold 10, and Arial 12 are considered different fonts because they
possess different characteristics.
- Remove any graphic objects from your worksheets, such as text boxes, drawn
items (polygons, rectangles, lines), worksheet "snapshots" (generated with
the Camera tool), and embedded charts.
NOTE: Drawn ovals may use a very large amount of GDI memory space.
- When you print, use a lower-quality print mode by lowering print resolution
or selecting the Fast But No Graphics check box in the Print dialog box.
- Turn off or remove options such as scroll bars, the status bar, split
windows, and the formula bar.
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.
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.
|
0 
