I recently converted to Home editions of Vista and Office 2007 because I needed to replace my old machine and couldn't wait. No big problems, except this one Excel workbook.
I manage my investments with an Excel workbook. I converted the workbook from 2003 to 2007. I can't go back to Office 2003.
There are currently eleven sheets with a number of equations working on data pulled across sheets. All my formulas are fairly straight arithmetic. There are some cells using finance functions, some of which I had to define myself. Those can involve a series of nested conditionals. These use some basic statistical functions -- COUNT and ACOUNT, AVERAGE, and similar functions. There are two graphs covering about 50 periods each. There are some custom numeric formats controlled by IF-THEN clauses to highlight unusual results.
Problem: Any data entry anywhere causes a 15-20 second pause. Mike 1001 had the same type of problem but his solution doesn't seem to apply to me.
What do I need to do to find the formula(s) causing the problem?
Bookmarks