My apologies if this has been addressed elsewhere. I've been trying in both Word 2010 and Word 2013 to Insert > Text from file and choosing a named range in an Excel file. However, each time I try this I get the following message:

The file xxx cannot be opened because there are problems with the contents.

This occurs even when I create a brand new Excel file and save it. Am I doing something incorrectly or is there a different way to do what I want other than copying from Excel and pasting into Word?

Thanks in advance!