Forum Discussion
Wayban
Jan 29, 2025Copper Contributor
Problem whit formulas
hola buen dia
tengo 2 libros de excell y estoy generando una formula de buscarv entre estos 2 libros pero no me lo permite, solo me permite ligar la formula si pertenece al mismo libro de excell. es la primera vez que me pasa esto y no se que configuracion me falta o se movio a mi excell.
espero me puedan ayudar
1 Reply
- Patrick2788Silver Contributor
It sounds like the workbooks are not open in the same session of Excel. If you go to the View menu and select Switch Windows - both workbooks must show. The recommended solution is to close the second workbook and re-open by going to File | Open from the first workbook. This will place both workbooks in the same session of Excel.