Hi,



I have been learning how to import data from Excel into a Word document. I have used the strategy of 1) Copy content from Excel and 2) Paste special in Word, selecting the "paste link" option together with the "HTML" option.

It is working to update the data when I modify the Excel spreadsheet and then click "Update Field" in Word.

However, the result is messing with my formatting. It is adding extra space above and below the imported numbers, and a table that should now fit onto one page is now spilling over onto a second page.

I have looked up many problems related to formatting of imported links and all the ways to adjust options in cells.

I can resize the cells manually, but check what happens when I select a desired row size of 0.7cm as compared to the 0.9cm that allows the text to fit in OK: there is too much extra space ABOVE the content and I cannot get rid of it. Any ideas? The images should make clear what my problem is. See the bottom row, how I resize and I lose the text below the line, but there is lots of extra space above? Even the cells above are not ideal. I resized them to hide extra space below, but now I cannot centre the outputs.

This matters because a) I solved the problem of automatically updating the Word document using data maintained in Excel, but b), this is introducing a problem where I can longer maintain the row size to fit a table on one page.

Attached Images

WhatsUp.png (2.6 KB, 15 views)

The spacing in Word should reflect the line spacing & alignment in Excel. Reducing the row heights in Word is of little benefit, as they'll revert the next time the link is refreshed. You may get results more to your liking with one of the other link formats.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Indeed. It was that simple. For some reason I only recognized HTML as the possible option that would link. But now I see that the descriptions are quite explicit that the other formats will also carry the links.

And I checked it with simple RTF to keep source formatting (which means it's also easy to export conditional formatting) and it works.

Thank you very much.