Text Boxes Randomly Offset After Saving

[BryanC]

Hi, I'm using Excel 2007 and I'm using text boxes in a visual hierarchy
system on a spreadsheet. When I save, everything looks nice and orderly but
when I open the spreadsheet again, some text boxes have jumped around and the
lines that were snapped to them don't look like they're snapped anymore.
Then when I move the text boxes a little bit, the lines immediately snap to
them again. Some text boxes are even all the way in the bottom corner,
squished together.

I've tried grouping and ungrouping text boxes but it doesn't seem to do
much. I am using the "align to grid" feature, though i don't think that's
the problem either.

 

[TheHeatons]

Hi, I'm using Excel 2007 and I'm using text boxes in a visual hierarchy
system on a spreadsheet.  When I save, everything looks nice and orderly but
when I open the spreadsheet again, some text boxes have jumped around andthe
lines that were snapped to them don't look like they're snapped anymore.  
Then when I  move the text boxes a little bit, the lines immediately snap to
them again.  Some text boxes are even all the way in the bottom corner,
squished together.

I've tried grouping and ungrouping text boxes but it doesn't seem to do
much.  I am using the "align to grid" feature, though i don't think that's
the problem either.

Hi Bryan,

I have a similar problem with Excel 2000 and 2007. I have also tried
the group/ungroup method often talked about.
The only solution I've found that seems to work most of the time is
to choose 'Dont Move or Size with Cells" from the Format Control |
Properties box.

Its not guarenteed but it may work for you.

Regards

David