Forum Discussion

Wayban's avatar
Wayban
Copper Contributor
Jan 29, 2025

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

  • Patrick2788's avatar
    Patrick2788
    Silver 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.

Resources