Problemas con función "BuscarX"

%3CLINGO-SUB%20id%3D%22lingo-sub-2500081%22%20slang%3D%22es-ES%22%3EProblems%20with%20%22XLookup%22%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2500081%22%20slang%3D%22es-ES%22%3E%3CP%3EWith%20several%20open%20spreadsheets%20interrelated%20with%20the%20function%20%22FindX%22%20At%20random%20moments%20Excel%20does%20not%20respond%20and%20I%20must%20close%20it%2C%20losing%20information%20in%20the%20process.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2500081%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2502491%22%20slang%3D%22en-US%22%3ERe%3A%20Problemas%20con%20funci%C3%B3n%20%22BuscarX%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2502491%22%20slang%3D%22en-US%22%3EUsing%20a%20lookup%20function%20against%20an%20external%20file%20is%20quite%20slow.%20I%20would%20create%20a%20query%20that%20fetches%20the%20data%20(the%20entire%20table)%20you%20are%20doing%20the%20lookup%20against%20and%20have%20the%20query%20place%20the%20results%20on%20a%20separate%20worksheet%20in%20your%20workbook.%20Then%20let%20all%20XLOOKUP%20functions%20use%20the%20table%20on%20that%20sheet.%3CBR%20%2F%3EMake%20sure%20the%20query%20refreshes%20when%20you%20open%20the%20file.%3C%2FLINGO-BODY%3E
Occasional Visitor

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.