Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2010 Severe  Performance Problem

Posted on 2010-11-22
5
Medium Priority
?
817 Views
Last Modified: 2012-05-10
We have a machine running Excel 2010 on a Windows 7 Professional 64-bit Intel i7 Processor running about 3GB of RAM.  

When my user opens a local native version of .xlsx document it takes over 30seconds to load and when doing some of the most basic alterations to the spreadsheet, the changes take literally minutes to complete.  

One example would be selecting a column and unbolding the content of all rows in that column.  The spreadsheet has just over 100,000 rows with about 3 formulas.  We purchased Excel 2010 in an effort to move beyond the 50,000 row limit of older Excel versions, but we honestly did not expect the performance to be this bad.

Has anyone seen any similar problems and are there any workarounds/solutions?

0
Comment
Question by:azpete
[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
5 Comments
 
LVL 4

Expert Comment

by:Wcombee
ID: 34188787
To be completely honest, when you are running an excel spreadsheet with over 100k rows, you will run into performance issues.

Even with the system you are running, it would probably be a good idea to have this amount of data to be in a sql database or something of that nature, and run any queries that you need, and pull the data from there.  
0
 
LVL 7

Expert Comment

by:Brad Sims, CCNA
ID: 34188847
Are any other users experiencing these types of slow-downs?  Does it happen also when he/she opens a copy of an Excel sheet that is on the network?
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34188967
Have you tried a different printer? A lot of these types of display-related performance issues can be traced to printer drivers.
0
 

Accepted Solution

by:
azpete earned 0 total points
ID: 34214019
FOUND THE SOLUTION  !

Turns out the problem was the size of our  Windows Page File.

Normally Microsoft recommends 1.5 times the amount of RAM

We have increased that to approx 9 times !

Our million line spreadsheet update time dropped from 2 minutes to 4 seconds !!!!!
0
 

Author Closing Comment

by:azpete
ID: 34237234
We found that increasing the PAGE FILE is Often a great way of solving performance problems.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

704 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