Forum Discussion
lot of VLOOKUP, IF, IFS made too slow.
a excel file, having 40 sheets, 400 rows in every sheet, containing at least 400 VLOOKUP, IF, IFS.
this makes the file too slow while editing single record. any solution for the same.
4 Replies
Plus exclude IFS and use nested IF instead. Former evaluates all conditions, latest stops evaluation on first TRUE.
And performance could be affected not only by formulae. That could be excess ranges formatting or conditional formatting, whatever.
- I saved the file with a `.xlsb` extension instead of `.xlsm` or `.xlsx`, which made it much faster to access.
- Thanks for your suggestion, I'll try it.
I have reduced the number of records per sheet from 400 to 150
It means
Vlookup in a single column 150
Number of columns is 10
Number of sheets is 35
It means 150x10x35=52,500
- My money goes to the VLOOKUP formulas. How many columns of VLOOKUP formulas do your sheets have?
