dmacmillan
Board Regular
- Joined
- Apr 5, 2004
- Messages
- 125
Hello All,
Wondering if there are known performance/stability issues when using Xlookup and Filter functions with multiple linked workbooks (15). Both functions is used intra-workbook and inter-workbook. Optimisation of the Profit and Loss file requires all other files be open.
I am informed the suite of files did not have stability issues last budget cycle - these files used Vlookup extensively but did not use the Filter function. The suite of files has evolved over many years, that pre-date my involvement.
Currently fending off concerns these formulae are not fit for purpose (the inference being Vlookup is a better option). Thought I was being progressive. Granted my experience of multiple linked workbooks is lean, as I would have anticipated performance issues.
Fully appreciate the limits of Excel are being pushed. Regrettably I cannot share these files due to the number, and the commercial sensitivity.
Many thanks in advance.
Kind regards,
David
Wondering if there are known performance/stability issues when using Xlookup and Filter functions with multiple linked workbooks (15). Both functions is used intra-workbook and inter-workbook. Optimisation of the Profit and Loss file requires all other files be open.
I am informed the suite of files did not have stability issues last budget cycle - these files used Vlookup extensively but did not use the Filter function. The suite of files has evolved over many years, that pre-date my involvement.
Currently fending off concerns these formulae are not fit for purpose (the inference being Vlookup is a better option). Thought I was being progressive. Granted my experience of multiple linked workbooks is lean, as I would have anticipated performance issues.
Fully appreciate the limits of Excel are being pushed. Regrettably I cannot share these files due to the number, and the commercial sensitivity.
Many thanks in advance.
Kind regards,
David