Excel in MS Office 365 - Named Range repeatedly corrupted - #REF error

%3CLINGO-SUB%20id%3D%22lingo-sub-1442871%22%20slang%3D%22en-US%22%3EExcel%20in%20MS%20Office%20365%20-%20Named%20Range%20repeatedly%20corrupted%20-%20%23REF%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442871%22%20slang%3D%22en-US%22%3E%3CP%3E'Small%20'%20workbook%20in%20Excel%20365.%20File%20has%208%20worksheets%2C%20max%20200%20rows%2C%2030%20columns.%20Extensive%20use%20of%20VBA%20code%20and%20Dynamic%20Named%20Ranges.%20No%20reported%20errors%20on%20opening%20file%20or%20on%20save.%20VBA%20code%20compiles%20without%20error.%20Have%20repeatedly%20retyped%20name%20range%20definition%20in%20'Refers%20to'%20box%20to%20get%20rid%20of%20%23REF%20error%20and%20re-saved%20file.%20Re-Open%20file%20and%20problem%20recurs.%20This%20is%20not%20applicable%20to%20all%20named%20ranges%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1442871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

'Small ' workbook in Excel 365. File has 8 worksheets, max 200 rows, 30 columns. Extensive use of VBA code and Dynamic Named Ranges. No reported errors on opening file or on save. VBA code compiles without error. Have repeatedly retyped name range definition in 'Refers to' box to get rid of #REF error and re-saved file. Re-Open file and problem recurs. This is not applicable to all named ranges 

0 Replies