Problemas con indirect

%3CLINGO-SUB%20id%3D%22lingo-sub-1936538%22%20slang%3D%22es-ES%22%3EProblems%20with%20indirect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936538%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20a%206-page%20book%20in%20one%20of%20which%20two%20drop-down%20lists%20are%20displayed%2C%20the%20first%20is%20from%20a%20specific%20range%20of%20sheet%203%20and%20the%20second%20is%20a%20list%20conditioned%20by%20the%20%3CBR%20%2F%3E%3CSTRONG%3Efunction%20'INDIRECT'''Sheet4'!%24A%242%3A%22%26amp%3BADDRESS(COINCIDIR(1%2CFIND(%22-%22%2C'Sheet4'!%24A%3A%24A)%2C0)%2C1))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EWhen%20generating%20the%20list%20this%20works%20properly%20without%20any%20problem%20and%20records%20the%20changes%20of%20sheet%204%20but%20after%20protecting%20the%20document%20and%20saving%20it%2C%20when%20opening%20it%20again%20the%20second%20list%20goes%20blank%2C%20is%20it%20the%20only%20drawback%20that%20is%20presented%2C%20already%20review%20all%20the%20other%20formulas%20and%20references%20and%20do%20not%20generate%20any%20problems%2C%20just%20as%20the%20selection%20range%20for%20%3CSTRONG%3Ethe%20INDIRECT%3C%2FSTRONG%3E%20works%20well%2C%20some%20advice%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1936538%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Tengo un libro de 6 paginas en una de las cuales se muestran dos listas desplegables, la primera es de un rango especifico de la hoja 3 y la segunda es una lista condicionada por la función 
=INDIRECTO("'Hoja4'!$A$2:"&DIRECCION(COINCIDIR(1,ENCONTRAR("-",'Hoja4'!$A:$A),0),1))

al momento de generar la lista esta funciona de manera adecuada sin ningún problema y registra los cambios de la hoja 4 pero después de proteger el documento y guardarlo, al abrirlo nuevamente la segunda lista se queda en blanco, es el único inconveniente que se presenta, ya revise todas las demás formulas y referencias y no me generan ningún problema, de igual manera el rango de selección para el INDIRECTO funciona bien, algún consejo?

0 Replies