XL98: Center Across Selection Cells Return 0 When Linked (191108)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q191108 SYMPTOMS
When you link to a cell, the value may unexpectedly return a value of
zero (0).
-or-
If you use Paste Link (Paste Special dialog box) the array returned
to the destination cells may look different than anticipated (display
zero values).
CAUSE
You may experience these problems if the Horizontal alignment of the source
cells is set to Center Across Selection.
In Microsoft Excel 98 Macintosh Edition, when you format a range of cells
with the Center Across Selection option, the contents of one cell will be
centered across multiple cells. In this format, although the data appears
to be contained in several cells, the actual data can only be accessed from
the original cell. For this reason, operations, such as those described in
the "Symptoms" section will not retrieve data from the cells that appear
filled.
WORKAROUND
To prevent these problems from occurring, copy only the first cell in the
range of cells formatted with Center Across Selection.
STATUS
This is by design of Microsoft Excel 98 Macintosh Edition.
REFERENCES
For more information about Center Across Selection, click the Office
Assistant, type center across selection, click Search, and then click to
view "Center, align, indent, or rotate data in a cell."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB191108 |
|---|
|