Excel 2013 Performance

Greetings Experts,

I'm having an issue with Excel 2013 taking a long time (3-5 seconds) to make a single cell calculation.  The spreadsheet was originally created in 2010 and has single worksheet with approximately 750 rows and 20 columns.  There are 3 calculations per row, and when you change a field that affects one of those calculations, you get the spinning circle / calculating mouse pointer for 3-5 seconds.  If you open the same workbook in 2010...no issues.

Thoughts?
LVL 5
DMJorgensenAsked:
Who is Participating?
 
DMJorgensenAuthor Commented:
Hi Guys,

Sorry for the delay, been out of the office.  
@Jose, I saw those articles about changing modifying the registry on the internet prior to posting here...it had no affect.  @Patrick, there was one row that was performing lookups from another spreadsheet (both files were on the workstation and not the network) but the delay was happening when changing a calculation in one cell and one row at a time.  We ended up re-creating the spreadsheet in Excel 2013 and the issue was gone.  There is something in the 2010 version that 2013 just didn't like.  
Thanks for the help anyway.
0
 
Jose ArriagaConsultantCommented:
Hi DMJorgensen

Did you try disabling Animation feature In Office 2013?

To disable Animation please run regedit.exe
then locate this key and change dword to 1.

[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Graphics]
"DisableAnimations"=dword:00000001

To see the effect, you’ll need to reboot your computer.

To reverse the effect, change the value of the added DWORD to its default of 0.
0
 
Patrick MatthewsCommented:
Without seeing the actual workbook it's hard to say.  But:
1) Due to formatting you may have many additional rows/columns in the used range.  Check that
2) Do you have any cells that have volatile functions?  These recalculate whenever the worksheet does, even if dependent/antecedent relations do not dictate that they normally would
3) Are you using any array formulas?
4) Are you using any User Defined Functions with VBA?
5) Are you using references to external files/data sources?
6) Are you using functions like SUMPRODUCT, COUNTIF, SUMIF, etc, which display array behaviors?
7) Are you using VLOOKUP or INDEX, which can get expensive if you are looking in large lookup tables?
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.