+ Reply to Thread
Results 1 to 2 of 2

Speeding up calculations

  1. #1
    Registered User
    Join Date
    08-02-2015
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    1

    Speeding up calculations

    G'day

    I am taking data taken from a data logger which records a current reading from machines every second for one week i.e 600,000 values. And am then using excel to analyse and plot the data. I am having trouble when pasting large ammounts of data into the workbook. Is there anything I can do to speed up the process or should I click paste and find something else to do for a while.
    So far I have done the following to help speed up the process
    - Enabled multi thread calculations
    - Turned calculations to manual only
    - Excel 2013 64bit
    - PC is I7-4790K @ 400GHz
    - 32GB ram

    Anything else I can do to speed up the process would be great.

    Cheers

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Speeding up calculations

    Hi Spacegoat and welcome to the forum,

    Making ScreenUpdating false is a normal method to speed things up. Also making calculations manual until the import is done might help. Read this site to see more:

    http://www.excelitems.com/2010/12/op...er-macros.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Speeding up a loop to repeat calculations for different inputs
    By violeta14 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2015, 06:02 AM
  2. Speeding up calculations
    By clundeen in forum Excel General
    Replies: 2
    Last Post: 02-10-2011, 09:58 AM
  3. Speeding Up File with Calculations
    By sly424 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2008, 02:55 PM
  4. Speeding up VBA
    By smurray444 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2007, 09:55 AM
  5. Speeding up macros
    By phil2006 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2006, 06:29 AM
  6. Speeding up workbook calculations
    By John in forum Excel General
    Replies: 1
    Last Post: 12-05-2005, 01:45 PM
  7. [SOLVED] help with speeding this up...
    By Simon in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-26-2005, 11:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1