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...
Attached are the 2 sprdshts I am currently using. One holds the nutrition data that the LOOKUP checks when I add a new entry to the nutrition log. The other is the nutrition log that accumulates the info.
First, get rid of the numerous conditional formatting rules.
Second, get rid of the unnecessary rows with formulas.
Separate data input from calculation and reporting.
Do not put data input on more than one sheet (e.g. one sheet for each month/quarter/year).
Use Excel tables.
Use Pivot to do the reporting
Use Power Query to the the calculation and/or reporting.