Nov 17 2020 04:16 AM
Hi! I am using word and excel 2020 on windows 10.
I am experiencing troubles while trying to insert a worksheet from excel to my word document.
I am selecting insert > object > text from file, then I am selecting my Excel file and in the range I write either the name of a worksheet or the range of cells (eg: A1:A7), but neither of the options work.
It is written that "Word found unreadable content in "name of the file. Do you want to recover the content of the file" and I press YES. And then another error message appears saying "Word has encountered problems" .
I find it very strange, because I did the same commands on my Mac OS yesterday, and it worked.
Has anyone experienced that and if yes, how did you resolved it?
Cheers
Nov 17 2020 04:31 AM
The Windows version of Word doesn't consider an Excel workbook to be "text".
Instead, do the following:
Nov 17 2020 04:39 AM
Nov 17 2020 04:50 AM
You'd have to automate Excel from Word. See:
Word VBA Macros – Tables: Add, Select, Loop, Insert From Excel