Solved

Excel 2010 vs. Excel 2007 Performance issues

Posted on 2014-04-23
7
605 Views
Last Modified: 2014-04-23
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
Comment
Question by:Maliki Hassani
  • 5
7 Comments
 
LVL 27

Assisted Solution

by:MacroShadow
MacroShadow earned 250 total points
ID: 40018373
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
 
LVL 19

Accepted Solution

by:
regmigrant earned 250 total points
ID: 40018379
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
 

Author Comment

by:Maliki Hassani
ID: 40018488
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Maliki Hassani
ID: 40018508
It does seem that my conditional formatting per cell has been duplicating.  I will do a clean up and see what happens.
0
 

Author Comment

by:Maliki Hassani
ID: 40018687
nothing..  No change in speed
0
 

Author Comment

by:Maliki Hassani
ID: 40018717
Update:  Think I may have fixed the issue still working it
0
 

Author Closing Comment

by:Maliki Hassani
ID: 40018727
thanks...  Needed some review of formulas..
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question