I have charts in XL2010 with rotated y-axis titles that I have pasted as OLE links into Word. I can resize the chart or update (F9) the chart when it is open and the formatting is maintained. However, when I reopen the file later the chart formatting is wrong sometimes- with the most obvious thing being that the y-axis title is no longer rotated (reads vertically from bottom to top with overlapping letters). Also, the chart lines are slightly bolder and slightly pixelated.

After pasting (paste special\linked\OLE) I am telling it to maintain formatting (with the \*MERGEFORMAT switch in the link) and I am turning off the auto update (via File\Edit Links\(select all)Manual). Save before exit.

I also have Excel tables, that I have linke to Word the same as I have done for the charts, that do not desplay the contents on reopen. I don't know if I'm making the same mistake with the tables as with the charts to lead to this...

What am I doing to cause this- or what can I change to maintain my formatting?

Thank you!