Excel 2010 vs. Excel 2007 Performance issues

Experts,

I just upgraded my computer due to speed issues (Windows XP to 2007).  With this upgrade my company gave me excel 2010, from excel 2007.  I have a macro enabled workbook that has quite a bit of calculations/conditional formatting.  The issue is that it was running just fine with Excel 2007, but now I can't even insert/remove a single cell without waiting 1 minute.  Then after I try to close the spreadsheet a dialog box states "Excel cannot complete this task with available resources. Choose less data or close other applications"  Continue without Undo?

Any ideas what I can do?
Maliki HassaniAsked:
Who is Participating?
 
regmigrantCommented:
A few things to try before we get into examining code and formulae

1. Does it happen with only this one file?
2. have you run all office updates?
3. do you have any add-ins installed?
4. have you tried in Safe Mode - hold ctrl as you start excel?
5. Have you tried saving under different file types - native and compatibility mode
0
 
MacroShadowCommented:
I use Window 7 with Office 2010, no issues. In fact 2010 is a lot better if terms of performance.

The error you are receiving has plagued Excel users for years, unfortunately there is no concrete solution.

Microsoft has a kb regarding troubleshooting of the error, since EE doesn't like (an understatement!) external links especially to Microsoft, I attached a copy of the article.
How-to-Troubleshooting-Available.mht
0
 
Maliki HassaniAuthor Commented:
1. Yes and No.. I have an older version of the spreadsheet which contains a few less sheets (similar formulas) and it runs a bit faster.. Which tells me that it doesn't like the amount calculations.

2. yes

3. no

4. yes

5. Yes

Nothing. :(
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Maliki HassaniAuthor Commented:
It does seem that my conditional formatting per cell has been duplicating.  I will do a clean up and see what happens.
0
 
Maliki HassaniAuthor Commented:
nothing..  No change in speed
0
 
Maliki HassaniAuthor Commented:
Update:  Think I may have fixed the issue still working it
0
 
Maliki HassaniAuthor Commented:
thanks...  Needed some review of formulas..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.