• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 639
  • Last Modified:

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?
0
Maliki Hassani
Asked:
Maliki Hassani
  • 5
2 Solutions
 
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
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now