performance xl 2010

Running Windows 10 & Office 2010. 1. Most of my Excel workbooks work fine...when no macros used. 2. My "budget" workbook has slow performance & freeze issues...it uses macros. 3. Some/most slowness is due to many imbedded, conditional formulas in 12 sheets. 4. Open & close workbook is slow. 5...

Using this code, the result of the debug.print are between 500 - 600 milliseconds. That's a half a second. I am running a loop of 2000 cells, so that adds up very quickly. Is there any other way to speed this up? For reference I have set these options first: Application.ScreenUpdating...

Good afternoon, I am experiencing a few performance issues and struggling to get to the bottom of it, I am using Windows 7 and Excel 2010, 32 bit. I am unsure if I am not understanding the issue, i.e. it lies in computer memory or should look to use an alternative formula. The problem: Once...