SOLVED

Error Solver No es posible activarlo

%3CLINGO-SUB%20id%3D%22lingo-sub-3429500%22%20slang%3D%22es-ES%22%3EError%20Solver%20Unable%20to%20activate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3429500%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20try%20to%20activate%20SOLVER.%20I'm%20going%20to%20Options%20-%26gt%3B%20Add-ins%20-%26gt%3B%20Excel%20Add-ins%20-%26gt%3B%20Go%20-%26gt%3BSelect%20SOLVER-%26gt%3B%20OK%3C%2FP%3E%3CP%3EAnd%20I%20see%20an%20ad%3A%3C%2FP%3E%3CP%3EMicrosoft%20Excel%20cannot%20access%20the%20file%20'C%3A%2FProgram%20Files%2FMicrosoft%20Office%2Froot%2FOffice16%2FLibrary%2FSOLVER%2FSOLVER.%20XLAM'.%20There%20can%20be%20several%20reasons%3A%3C%2FP%3E%3CP%3E-%20The%20name%20or%20path%20of%20the%20file%20does%20not%20exist.%3C%2FP%3E%3CP%3E-%20Another%20program%20is%20using%20the%20file.%3C%2FP%3E%3CP%3E-%20The%20book%20you%20are%20trying%20to%20save%20has%20the%20same%20name%20as%20another%20book%20that%20is%20currently%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20uninstall%20and%20install%20Office%20again%2C%20using%20the%20Microsoft%20Support%20and%20Recovery%20Assistant.%3C%2FP%3E%3CP%3ELikewise%2C%20a%20technician%20has%20already%20carried%20out%20the%20complete%20online%20repair%20of%20Office.%20But%20the%20problem%20was%20not%20solved.%3C%2FP%3E%3CP%3EPlease%20ask%20for%20help%20to%20fix%20this%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3429500%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3430191%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20Solver%20No%20es%20posible%20activarlo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3430191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1401859%22%20target%3D%22_blank%22%3E%40MaxBallena%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EMaybe%20this%20will%20help...%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFile%26gt%3BOptions%26gt%3BAdd-ins%26gt%3BSelect%20%22disabled%20add-ins%22%20from%20the%20list%20%26gt%3B%20Go%20%26gt%3B%20Enable%20solver%3C%2FP%3E%3CP%3Eonce%20that%20is%20done%2C%20then...%3C%2FP%3E%3CP%3EFile%26gt%3BOptions%26gt%3BAdd-ins%26gt%3BSelect%20%22Excel%20add-ins%22%26gt%3BSelect%20%22Solver%22%20from%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3431382%22%20slang%3D%22es-ES%22%3ERe%3A%20Error%20Solver%20Unable%20to%20activate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431382%22%20slang%3D%22es-ES%22%3EThanks%20a%20lot.%20Worked%20perfectly%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3431959%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20Solver%20No%20es%20posible%20activarlo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3431959%22%20slang%3D%22en-US%22%3EFue%20un%20placer%20poder%20ayudarte%20%3A).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3546161%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20Solver%20No%20es%20posible%20activarlo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3546161%22%20slang%3D%22en-US%22%3EMuchas%20gracias!%20ten%C3%ADa%20el%20mismo%20problema%20y%20pude%20solucionarlo%20con%20eso!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3550091%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20Solver%20No%20es%20posible%20activarlo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3550091%22%20slang%3D%22en-US%22%3EGracias%20por%20tus%20comentarios%2C%20seguro%20que%20otros%20usuarios%20tambi%C3%A9n%20ayudar%C3%A1n%20cuando%20vean%20que%20funciona.%3CBR%20%2F%3E%3CBR%20%2F%3ELe%20deseo%20%C3%A9xito%20continuo%20con%20Excel.%3C%2FLINGO-BODY%3E
New Contributor

Intento activar SOLVER. Voy a Opciones -> Complementos -> Complementos de Excel -> Ir - >Selecciono SOLVER-> Aceptar

Y me aparece un anuncio:

Microsoft Excel no puede obtener acceso al archivo 'C:/Program Files/Microsoft Office/root/Office16/Library/SOLVER/SOLVER.XLAM'. Puede haber varios motivos:

- El nombre o la ruta del archivo no existen.

- Otro programa está usando el archivo.

- El libro que está intentando guardar tiene el mismo nombre que otro libro que está abierto en estos momentos.

 

Ya desinstale e instale nuevamente Office, con el Asistente  de Soporte y Recuperación de Microsoft.

Así mismo, ya un técnico realizó la reparación online completa de Office. Pero el problema no se solucionó.

Por favor, solicito ayuda para solucionar este problema.

5 Replies
best response confirmed by MaxBallena (New Contributor)
Solution

@MaxBallena 

Maybe this will help...

File>Options>Add-ins>Select "disabled add-ins" from the list > Go > Enable solver

once that is done, then...

File>Options>Add-ins>Select "Excel add-ins">Select "Solver" from the list.

 

 

NikolinoDE

Muchas gracias. Funcionó perfecto
Fue un placer poder ayudarte :).
Muchas gracias! tenía el mismo problema y pude solucionarlo con eso!
Gracias por tus comentarios, seguro que otros usuarios también ayudarán cuando vean que funciona.

Le deseo éxito continuo con Excel.