Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

Best computer configuration for running big excel macro files

This is a discussion on Best computer configuration for running big excel macro files within the Microsoft Office support forums, part of the Tech Support Forum category. Hello, I'm from the netherlands so my english is not perfect-) I got a problem so mayby you can helmp

Closed Thread
Thread Tools Search this Thread
Old 06-01-2009, 06:35 AM   #1
Registered Member
Join Date: Jun 2009
Posts: 1
OS: xp


I'm from the netherlands so my english is not perfect-)

I got a problem so mayby you can helmp me. I buyed a computer last week using mostly for running big excel files (60mb-80mb) with macros.

To get aidea about my system take a look at this link http://www.azerty.nl/winkelmandje/w...ct%5B97107%5D=1

There's also a asus triton 81 cooler.

I'm using xp 32 bit right now, so the memory is only used for 3,2 mb instead of 6 mb. I gonna install wednesday vista ultimate 64 bit, so the full 6mb will be used.

Today i run for the first time a excel file of 66mb with a macro. It started very fast but each minute it was going down in speed and finnally after 30-40 minutes it was going so slow it was doing only 1 adaptation (don't know if this it the correct english word) and with 55.000 adaptation to go it would take probaly days to get this file done.

Now is my question how can i upgrade or add something to my computer so it keeps running on the speed from the first minutes. So it's not losing speed how longer it runs.

Hope you can help me,thx

rocro is offline  
Sponsored Links
Old 06-01-2009, 12:55 PM   #2
Team Manager, Articles
Rangemaster, TSF Academy
Glaswegian's Avatar
Join Date: Sep 2005
Location: Glasgow
Posts: 39,424
OS: Windows 10 Pro

My System

Hi and welcome

Have a look at this site


They have many hints and tips on making Excel run and calculate faster.
Iain - Defender of the Haggis and all things Scottish.
I don't help by PM - post in the Forums.

PC Safety & Security::PC running a bit slow?::Photographers Corner
Glaswegian is offline  
Old 06-02-2009, 12:39 PM   #3
TSF Enthusiast
Elkar's Avatar
Join Date: Mar 2008
Location: Washington State, USA
Posts: 1,515
OS: Win 7, Vista, XP SP3

You probably won't see much improvement by upgrading to 64-bit Vista. Windows applications are limited to 2GB per instance, regardless of how much is available to the system.

What version of Excel do you have? Excel 2003 and older versions can only use 1 processing core for calculations. Assuming your new system has a dual (or quad) core processor, you'd need Excel 2007 in order to take advantage of the additional cores.

Elkar is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Post a Question

» Site Navigation
 > FAQ

All times are GMT -7. The time now is 06:55 PM.

vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Copyright 2001 - 2015, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts


Partially Powered By Products Found At Lampwrights.com