Export to Word - the Named Range name appears instead of data
Overview
When generating a Word document using the Jet Report Export to Word feature, the name of a named range appears in the document instead of the data:
Cause:
After the Word template was created (in this example using the named range CustomerNo.), the name of that range was changed within the Excel file itself:
Because the names no longer match, the Export to Word feature is not able to find the data.
Preferred Resolution Process
Use Excel's Name Manager to return the name back to what is used in the template created for your report.
Alternate Resolution Process
If it is necessary to keep the new name of the range, it will be necessary to edit the Word Export template.
-
From the Jet ribbon, select Configure Word Export
You'll see that the cell reference for the renamed range is missing
-
Select the new Name from the appropriate pull-down list:
Click Save
-
Go to the Template tab and click the Edit Template button.
You'll see the old name in the template:
-
Select that name by clicking the three dots
and then press the Delete key on your keyboard.
-
Add the NEW field name to the same location.
Close the Word template.
Click the Save button on the Configure Word Export window.
-
You should now be able to generate your Word document with the correct data.