Closed Thread
Results 1 to 3 of 3

Make faster calculation

  1. #1
    Forum Contributor
    Join Date
    01-31-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    191

    Make faster calculation

    Hi All,

    I have a Excel template for my Humidity and Temperature reading
    With the help of the forum expert (Vikas_Gautam) http://www.excelforum.com/members/575994.html
    I achieved what I want but my computer is so slow.

    Is there any method that makes the calculation faster? because if I will apply it to my datasheet that containing
    20 sensors my computer takes time to calculate the given data.

    Please find the attached template.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,982

    Re: Make faster calculation

    Turn the calculation off to Manual. Calculate only when necessary. It is a large sheet with multiple calculated cells. With each update, it will recalculate each cell holding a formula. Alternatively, you could opt for a faster machine. Multiple processors, etc.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,982

    Re: Make faster calculation

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make faster calculation
    By thong127 in forum Excel General
    Replies: 2
    Last Post: 09-08-2015, 12:16 PM
  2. How to make excel run faster?
    By melanie castro in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-24-2015, 05:44 AM
  3. [SOLVED] Make VBA Faster
    By icondor517 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-29-2013, 07:42 AM
  4. [SOLVED] Make code run faster
    By ozhunter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2013, 04:26 AM
  5. Rewriting sumproduct formula for faster calculation
    By jimstrongy in forum Excel General
    Replies: 1
    Last Post: 04-25-2012, 12:57 PM
  6. Faster Calculation than SumProduct?
    By leem in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2009, 03:58 PM
  7. can you make this faster?
    By John in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2005, 04:05 PM

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