WD2000: Cannot Insert File Using Named Range of Excel File

• Microsoft Word 2000

SYMPTOMS

When you attempt to insert a Named Range from an Excel file, the following error message appears:

The document name or path is not valid. Try these suggestions.
* Check the file permissions for the document or drive.
* Use the File Open dialog box to locate the document.

WORKAROUND

When you want to insert a Named Range contained in an Excel file into Microsoft Word, do the following:

1. On the View menu, point to Toolbars and click Database.



2. On the Database toolbar, click Insert Database.



3. In the Database dialog box, click Get Data.



4. In the Open Data Source dialog box, change the Files of type box to MS Excel Worksheets (*.xls) and click to select your Excel file.
   
   NOTE: You may need to change the Look in box to the folder that contains your Excel worksheet.



5. In the Open Data Source dialog box, select the Select method check box, and then click Open.



6. In the Confirm Data Source dialog box, click Excel sheets via ODBC (*.xls) and then click OK.



7. In the Select Table dialog box, click the table (Named Range) you want that is contained in your Excel worksheet, and click OK.



8. In the Database dialog box, click Insert Data.



9. In the Insert Data dialog box, click the range of records you want to insert, and click OK.
   
   For example, if you want to use all of the records contained in the Named Range, click All.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords : kbdta wd2000
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug