Excerpt from workbook.xml<definedNames>
<definedName name="Energy_of_Cooking" localSheetId="0" hidden="0">=Lists!$A$247</definedName>
- Backup the destination workbook, the one to receive named ranges from other source workbook
- Change source workbook extension from .xlsx to .zip
- Open source.zip, open xl/workbook.xml
- Copy section or copy entries to import
- Open destination.zip, export xl/workbook.xml, open in plain text editor
- Add to workbook.xml your source defined names, save
- Update destination.zip with workbook.xml, save
- Change destination workbook extension from .zip to .xlsx
- Open destination workbook, check imported defined names