Forum Discussion
What causes Excel to use excessive CPU time and generate an 'Excel not responding' msg w/each entry?
Hi,
There are some tips that you can follow to speed up the lookup functions calculations and prevent the workbook from crashing.
One of them is to use the 64-bit version of Excel, especially, if you have a huge number of lookups in the workbook.
Could you provide a sample of your workbook and formulas to see how we can help?
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.
Hi,
The workbooks are works on my machine without any crash or slowness!
I think the reason is that I have the 64-bit version of Excel!
On the other hand, if you have the latest version of Office 365, consider using VLOOKUP instead of LOOKUP because VLOOKUP got a huge boost in its performance as I think that the old LOOKUP doesn't take advantage from the latest update!
Please check out this link.
Hope that helps
OK, thanks for the feedback. I'll move to the 64 bit version.
- Sorry for the naming confusion. I'm still working on these and have renamed them from food consumption to nutrition. The ones listed above are the files that I am trying to 'fix'. No luck yet. I don't see any errors but am probably not looking at the right stuff.
