Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Speeding up Excel - Large amounts of data, no complex formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tbrowne@gmail.com - 27 Sep 2006 15:00 GMT
Hi There,

I am currently investigating what is the most cost effective way of
speeding up excels calculations for large spreadsheets.  The sheets do
not contain what I would consider to be overely complex formulas with
the main tools being VLOOKUP, with maybe a few nested IF statements.
No complex maths as it mainly database manipulation type activity.

Currenlty it is taking too long to recalculate and even with manual
calculation enable is proving to be a hinderance to productivity.  I
was wondering if this is solvable by building a more suitable PC unit
or if the best way to go about it lies outside upgraded hardware.  If
it is hardware, what sort of components should I be looking at for an
excel screamer.

Thanks.
ExcelJockey - 28 Sep 2006 02:14 GMT
without knowing the details..

possibilities, get more RAM for your PC or upgrade the whole box, fin
and fix the bottlenecks (google "excel spreadsheet recalculatio
bottlenecks" for analysis tools) by rewriting the slow parts, o
if the spreadsheet is really massive, consider distributing th
computation using the features of the upcoming Office 12

-----------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/profile.php?mode=viewprofile&u=
View this thread: http://www.exceljockeys.com/forums/viewtopic.php?t=30766
Roger Govier - 28 Sep 2006 08:18 GMT
Hi

Take a look at Charles William's site for help on tracing bottlenecks
and gaining speed improvements.
http://www.decisionmodels.com/

Signature

Regards

Roger Govier

> Hi There,
>
[quoted text clipped - 12 lines]
>
> Thanks.
Huff - 28 Sep 2006 11:03 GMT
Probably a better bet would be to import the sheets into Access (or
another database application) and perform the calc's in there. Would be
a lot faster, and probably as cheap as building a better PC...

Cheers

> Hi There,
>
[quoted text clipped - 12 lines]
>
> Thanks.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.