Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 822
  • Last Modified:

Excel 2010 Severe Performance Problem

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
azpete
Asked:
azpete
1 Solution
 
WcombeeCommented:
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
 
Brad Sims, CCNANetwork AdministratorCommented:
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
 
Rory ArchibaldCommented:
Have you tried a different printer? A lot of these types of display-related performance issues can be traced to printer drivers.
0
 
azpeteAuthor Commented:
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
 
azpeteAuthor Commented:
We found that increasing the PAGE FILE is Often a great way of solving performance problems.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now