Article ID: 155949
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Word 95 Standard Edition
- Microsoft Word 6.0 Standard Edition
- Microsoft Word 6.0a
- Microsoft Word 6.0c
- Microsoft Word 6.0 for Macintosh
- Microsoft Word 6.01 for Macintosh
- Microsoft Word 6.01 for Macintosh
- Microsoft Word 98 for Macintosh
This article was previously published under Q155949
SYMPTOMS
Word 98
When you create a link to a Microsoft Excel object while the Excel
worksheet is open, the object resembles a table with columns and rows. It
may include columns and rows that do not contain data. When you create a
link to the same Excel object while the Excel worksheet is closed, the
object includes only the cells that contain data. There are no extra empty
columns or rows. This problem occurs when you create the link via the
Create From File tab. (To locate this tab, click Object on the Insert
menu.)
For example, if cells A1 to B2 in the Excel worksheet contain data, and you
create a link to this file while the worksheet is closed, the result looks
like this:
--------------
| 123 | 456 |
| 123 | 456 |
--------------
If you create a link to the same spreadsheet while the Excel worksheet is
open, the object looks like this:
--------------------------------------------
| 123 | 456 | | | | | |
--------------------------------------------
| 123 | 456 | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
| | | | | | | |
--------------------------------------------
The object may also take on different characteristics regardless of whether
Float Over Text is selected.
Word 6.x (Windows), 7.0
When you create a link to an Excel object while the Excel worksheet is
open, the object resembles a tiny, shaded table at high resolutions. It is
similar in size to an object you insert when the Excel worksheet is closed.
It may include columns and rows that do not contain data. When you create a
link to the same Excel object while the Excel worksheet is closed, the
object includes only the cells that contain data. There are no empty
columns or rows. This problem occurs when you create the link via the
Create From File tab.
Word 6.x (Macintosh)
When you create a link to an Excel object while the Excel worksheet is
open, the object resembles a table, with columns and rows. It may include
columns and rows that do not contain data. When you create a link to the
same Excel object while the Excel worksheet is closed, the object includes
only the cells that contain data. There are no extra empty columns or rows.
However, the object may be 4 to 6 inches in width. This problem occurs when
you create the link and click From File in the Insert Object dialog box.
WORKAROUND
To work around this problem and insert only the cells that contain data,
close the Excel worksheet before you create the link to the file. To
ensure that all objects have the same characteristics, choose one method to
insert the objects.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: 8.0 8.00
Keywords: kbbug KB155949