I'm trying to copy content from Excel into a Word report and have it automatically update. The process I'm using:
1. in Excel, copy the cell with the desired data
2. switch to Word and paste
3. click the paste options icon that appears beside the pasted text, and select: "Match Destination...