Icon for inserted file object doesn't collapse away when closeoutline group

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I'm using Excel 2003 on Windows XP. I created a table with some
outline groups (grouped up by row). I also embedded some Word and
email (msg) files into some of the cells using Insert->Object-
CreateFromFile, unchecked "Link to file", and checked "Display as
Click to expand...
icon". When I collapse a group, the icons for the embedded files
still linger, disembodied-like. Is there a way to make them go away
like the rest of the grouped rows when the group is collapsed?

Thx.
 
Make sure the icon is completely within the cell (or row).

Then rightclick on the icon
Format Object|Properties tab|check "move and size with cells"
 
Works like a charm. Thx.

Make sure the icon is completely within the cell (or row).

Then rightclick on the icon
Format Object|Properties tab|check "move and size with cells"
Click to expand...
 
Back
Top