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



Hello,

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

Regards
Roy

__________________
rocro is offline  
Old 06-01-2009, 12:55 PM   #2
Team Manager, Articles
Analyst
Rangemaster, TSF Academy
 
Glaswegian's Avatar
 
Join Date: Sep 2005
Location: Glasgow
Posts: 38,462
OS: Win XP Pro SP3 / Win 7 Pro

My System


Hi and welcome

Have a look at this site

http://www.decisionmodels.com/calcsecrets.htm

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,514
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.

HTH
Elkar
__________________
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
  > 10.0.0.2


All times are GMT -7. The time now is 07:11 PM.


Copyright 2001 - 2014, Tech Support Forum

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