Problemas con función "BuscarX"

[Alecampcorp]

Con varias planillas abiertas interrelacionadas con la función "BuscarX" En momentos aleatorios Excel No responde y debo cerrarlo, perdiendo información en el proceso.

[#2]

Using a lookup function against an external file is quite slow. I would create a query that fetches the data (the entire table) you are doing the lookup against and have the query place the results on a separate worksheet in your workbook. Then let all XLOOKUP functions use the table on that sheet.
Make sure the query refreshes when you open the file.