• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Iteration

G

GN0001

Member
When the Excel workbook is very sluggish, do we need to enable iterative calculation?

Can we set as high as we want to speed up the calculation in our workbook?

Regards,

Guity
 
Iterative calculation is used for circular references.

http://chandoo.org/wp/2010/09/16/excel-circular-references/


If your pc is sluggish

Close all non-essential applications

Close all non-essential workbooks

Change calculation to Manual not Automatic


With your Excel model

Change away from Volatile Functions where you can


Sumproduct is one of several functions which are known as Volatile Functions.

These Volatile functions recalculate every time a spreadsheet change occurs as opposed to other functions that only recalculate when part of there precedence tree changes.


If your using Excel 2007/10 you can try replacing Sumproduct with Sumifs


For a more complete description of Volatile Functions check out:

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


failing these


Upgrade memory

New PC Time
 
Second time this day I am sharing this link...


http://msdn.microsoft.com/en-us/library/aa730921.aspx


Read through this article to improve performance of your workbooks...


~Vijay

sharma.vijay1@gmail.com
 
You must log in or register to reply here.
Back
Top