Excel display linked picture improperly when merged cells are on the same sheet IN EXCEL 2010

Excel display linked picture improperly when merged cells are on the same sheet.  This is not a problem with Excel 2003 and works sometimes in Excel 2007. excel linked picture  excel linked picture Excel-2007-10-causes-linked-pict.xlsx
VisionChainAsked:
Who is Participating?
 
Rory ArchibaldCommented:
Looks like a bug. Workarounds appear to be to not use merged cells (always a good plan) or move the source data so that it does not occupy the same area as the merged cells on your sheet.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

adding to rorya's suggestion, I find that the top banner merged cells are the real culprit. The other two merged cells don't seem to have much influence.

Are you aware of the formatting option "Center across selection", which you can use instead of merging cells? You can find it on the Alignment tab of the Format dialog.

Your banner occupies three rows. Check if you cannot use one row that is three times as high and use "Center across selectio" instead.

cheers, teylyn
0
 
VisionChainAuthor Commented:
No solution was provided.  I had to take another approach.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Rory ArchibaldCommented:
Two suggestions were made, with no response to either.
0
 
VisionChainAuthor Commented:
For each comment I clicked "No" on the "Was this comment helpful" section
0
 
Rory ArchibaldCommented:
That doesn't actually notify us of anything. As a general rule it's more helpful to post a reply telling us that it can't be used and why.
0
 
VisionChainAuthor Commented:
Problem could not be solved.  Appears to a bug with Excel 2010 or greater
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.