Paste special issue From Excel to Word

Question

I have an Excel 2013 document with numerous tables of data in it. I also have a Word 2013 document with blank table cells in it. I want to link the Word document to the Excel document so that when the Excel document is updated with new data, the Word document also updates.

My issue is that when I choose numerous cells in Excel, select the same number of cells in Word, and then paste in the data using the paste special command, ALL of the Excel cells are placed into the upper-left cell in Word. Strangely, regular pasting hasn't had a problem with this. Just the unique pasting. I can special paste one cell at a time, but in my case, that's thousands of cells, and not worth my time if there's a better way. So, is there a way to paste special multiple cells from Excel into a multiple cells in a Word table?

Answer 1

Since the table in the word document is empty, you might try copying the full table in excel and then replacing the word document table with it (or delete the word table first, and then do a special paste)

I hope this helps you.