VLOOKUP is the most convenient EXCEL built-in function. However, this is also the root cause of slowness in EXCEL where we need to wait for the auto-calculation to completes.
Seems like no constructive solution. My practice is to off the auto-calculation before opening the problematic files (going to Tool > Option > Calculation > Manual Calculation). F9 when you want to re-calculate, and turning it ON again when finishes using the problematic files.
Another way, is to see whether we can substitute VLOOKUP with simpler excel functions. Just no idea how to go about yet. Arghhh…
No comments:
Post a Comment