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, 17 views)