Solved

Excel 2013 Performance

Posted on 2015-01-22
3
121 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

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
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…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

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