asked on

Messy Fonts After Saving Linked Word Docs.

We use Excel and Word to build financial statements. We copy from Excel and do a "paste special, link, excel" into Word. If we print the statement right away it all looks great. If we save, close, reopen and print, the fonts get a little smashed together. It's like the proportion spacing on the fonts get messed up. This problem seems to be worse since we switched to Office 2007. Has anyone else been frustrated by this? Does anyone have a solution?

David L. Hansen

I've noticed that if I paste special as you describe, close and then reopen the document the text does get squished. As I experimented with it I noticed that if I click and highlight the pasted table in Word, right-click on it, then choose "Format Object" I can there reset the objects size (by clicking on the "Reset" button at the bottom right corner of the dialog box). This "unstretches" the object so the font looks clean again. If there is only a slight change in size you'll likely be fine I suppose. If however, the "unstretching" is over a large area then your table will be too big for the page.

Let me know which case you are dealing with.

kferreira

ASKER

I tried the reset button and it does not help. Some of the letters are still on top of one another. There is always a big space after capital "A" and almost no space after lowercase "m". I'm wondering if windows is somehow substituting the fonts. Again if I relink the Excel item into Word it looks great until I save, close, reload and print. We are using Times New Roman 11 point. I even tried switching the font to CG Times.

ASKER CERTIFIED SOLUTION

David L. Hansen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

David L. Hansen

Paste as Picture may work for you too.

kferreira

ASKER

Thank you sl8rz. The item about pasting and using the drop down box in the corner might work. They are only concerned that the line width is little thinner than it used to be.

David L. Hansen

Click in the table in Word. The whole table should auto-highlight. The upper-left corner of the table will have a little square with something like cross-hairs in it. Right-click on it and choose "Borders and Shading" from the menu. There you can adjust the line width.

kferreira

ASKER

The lines disappear when I try that, even if I specify 6 points. If I switch it back to the original setting of 1/2 point the lines are still not there.

David L. Hansen

I suspect that the color has somehow been changed to white or that the "Setting" was changed to 'none' (also in the borders and shading dialog box...borders tab).

kferreira

ASKER

sl8rz did an awesome job of helping me in a very timely manner. Thank you.

The second part of issue with the lines being too thin might not be important. Our office person will need to edit each line individually or managment might accept the thinner lines.