The Spreadsheet supports names that are defined within the global worksheet level (Workbook). However, when uploading a file that contains defined names, which scope is the local worksheet level (for example, Sheet1), the names are not available.
For example, upload the attached file in the Spreadsheet in the following online demo.
The name defined in the scope of "Sheet1" is not available:
Please improve the Spreadsheet to support names defined in the scope of the sheet?