Excel Data Validation List doesn't show results

%3CLINGO-SUB%20id%3D%22lingo-sub-441580%22%20slang%3D%22en-US%22%3EExcel%20Data%20Validation%20List%20doesn't%20show%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-441580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CBR%20%2F%3EI%20am%20using%20a%20formula%20in%20my%20data%20validation%20(option%3A%20list)%20with%20indirect%20(using%20calculated%20references%20in%20formulas%20too).%20This%20works%20fine%20when%20i%20am%20using%20Excel%20(the%20program%20is%20open).%20The%20problem%20starts%20when%20i%20close%20the%20workbook%20because%20when%20i%20open%20again%20it%20seems%20like%20the%20formula%20is%20not%20autocalculating%20itself%20and%20doesn't%20show%20me%20the%20results%20i%20need%20in%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPD%3A%20There%20are%20other%20formulas%20in%20my%20workbook%20and%20works%20fine%20while%20closing%20and%20opening%20the%20program.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20anyone%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-441580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor


I am using a formula in my data validation (option: list) with indirect (using calculated references in formulas too). This works fine when i am using Excel (the program is open). The problem starts when i close the workbook because when i open again it seems like the formula is not autocalculating itself and doesn't show me the results i need in the list.

 

PD: There are other formulas in my workbook and works fine while closing and opening the program.

 

Please anyone help me.

0 Replies