when importing a spreadsheet which has named ramges the named ranges are not imported. So any cells that reference these by range name do not work.
See attached file for demo.
Frankly, named ranges are not supported by Kendo Spreadsheet. I encourage you to post a feature request here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback.
A possible alternative is to use server-side approach to import the excel file and process it by using RadSpreadProcessing library. Which will eventually enable you to transform the named ranges to cell ranges. http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/named-ranges.