Forum Discussion
What causes Excel to use excessive CPU time and generate an 'Excel not responding' msg w/each entry?
I have a LOOKUP table with ~ 1500 x 10 elements. It contains a list of foods and all the nutritional factors for each. The next worksheet is used to track food consumption by entering the food name...
Another possibility is that your lookups might be using volatile functions, such as OFFSET and INDIRECT. Avoid them, if possible.