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