Were these named ranges created with a macro? I am probably telling you the obvious, but Excel2007 requires a special extension for workbooks with macros ('Macro-enabled Workbooks': '*.xlsm').