Solved

What steps to take in order to improve Excel 2010 (64 bit) performance

Posted on 2014-09-17
5
155 Views
Last Modified: 2016-11-23
Hi All,

I have an employee that using big excels and I would like to improve her performance
she has a very strong Dell Desktop CPU i7 with 16GB memory and SATA Hard disk but still her excel  slow  ( I installed the 64 bit version)
Btw Her excel is full of tabs filled with functions and Vlookups ..
I thought of buying an SSD drive that will improve her performance but I am not sure that this will help and really give the boost in performance
I wondered what do you think / recommend is the best way to improve and give the boost in performance?
0
Comment
Question by:Tufin
  • 2
  • 2
5 Comments
 
LVL 3

Assisted Solution

by:Josef Al-Chacar
Josef Al-Chacar earned 250 total points
ID: 40327742
There is a program that is called RAMDISK that pretty much allocates a portion of your ram as a separate disk, You could move the document there and it would speed it up. Large excel docs go very slow usually. As you said an SSD would be the best way to improve overall performance too. HDDs are a common bottleneck on PCs regardless of ram or CPU.
0
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 250 total points
ID: 40327902
Is setting the manual calculations an option? Since every time when you change the tab excel is calculating the formulas and this will speed up the browsing and then when needs calculations just hit F9..

This option helped worked with my colleagues in finance with similar issue..
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 40332112
I suspect the issue is simply inefficient formulas, especially if she uses lots of VLOOKUPs. You'd be better off looking at the formulas in use than simply trying to throw more/better hardware at a bad workbook, IMO.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40332125
Also, regarding to multiple VLOOKUPs, if you code those formulas in VBA it will be much faster and much cleaner(shorter formula).

One i had an issue with one of my colleague who had an excel formula with additions based on the vlookuops and after some time excel started to give error "Formula is too long" then i coded VBA code for same formula. It was much , much faster.

Maybe you can thing in that direction it will be cheaper than new hardware (SSD)..
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 40332899
A well written formula should generally be a lot faster than VBA.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now