It seems that EM doesn’t detect names ranges that are on a worksheet with a space in the name. See attached for reproducible example
named_range_test_with_space.xlsx is a copy of named_range_test.xlsx with only one change – the worksheet is renamed to have a space.
The spreadsheet metadata and Export to Spreadsheet (Named range) dropdown do not detect the named ranges in the 2nd workbook with a space in the sheet name
named_range_test_with_space.zip (14.0 KB)