Speeding up Excel - Large amounts of data, no complex formulas tbrowne[ at ]gmail.com 27.09.2006 14:00:00 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.

re:Speeding up Excel - Large amounts of data, no complex formul ExcelJockey <ExcelJockey.hhxnfm[ at ]exceljockeys-nospam.com> 28.09.2006 01:14:46 without knowing the details... possibilities, get more RAM for your PC or upgrade the whole box, find and fix the bottlenecks (google "excel spreadsheet recalculation bottlenecks" for analysis tools) by rewriting the slow parts, or if the spreadsheet is really massive, consider distributing the computation using the features of the upcoming Office 12. ------------------------------------------------------------------------ ExcelJockey's profile: http://www.exceljockeys.com/forums/profile.php?mode=viewprofile&u=4 View this thread: http://www.exceljockeys.com/forums/viewtopic.php?t=307666

Re: Speeding up Excel - Large amounts of data, no complex formulas "Roger Govier" <roger[ at ]technologyNOSPAM4u.co.uk> 28.09.2006 07:18:09 Hi Take a look at Charles William's site for help on tracing bottlenecks and gaining speed improvements. http://www.decisionmodels.com/ -- Regards Roger Govier <tbrowne[ at ]gmail.com> wrote in message news:1159365600.649475.272750[ at ]i3g2000cwc.googlegroups.com... [Quoted Text] > 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. >

Re: Speeding up Excel - Large amounts of data, no complex formulas "Huff" <douglas.hough[ at ]baesystems.com> 28.09.2006 10:03:21 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 tbrowne[ at ]gmail.com wrote: [Quoted Text] > 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.