3 How to prepare Excel documents
Requirements for your Excel documents are:
- They must be located in a Sharepoint or OneDrive where you (and the people you intend to collaborate with) have access to the files.
- You must use the “Define Name” feature in Excel.
3.1 How to “Define Name” in Excel for tables and cells
You need to give your table/cell a label or “define name” in order for “Excel2Word by Wrepit” to register and find the table or cell.
- Select the table/cell you wish to use.
- At the very top select the “formula” tab.
- Click on “Define Name”
- Name your table/cell
- Success!
Alternatively, you can right-click your selection and find “Define Name” in the right-click menu.