Forum Discussion
Problemas con función "BuscarX"
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.
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.
Make sure the query refreshes when you open the file.