Solved

Excel 2013 Performance

Posted on 2015-01-22
3
126 Views
Last Modified: 2016-02-11
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?
0
Comment
Question by:DMJorgensen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Expert Comment

by:Jose Arriaga
ID: 40564455
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
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 40564562
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
 
LVL 5

Accepted Solution

by:
DMJorgensen earned 0 total points
ID: 40588783
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

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

624 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