SYMPTOMS
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 worksheet 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.