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.
1 Reply
- 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.
