Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Recalculating continually

    I have a workbook with about 6 tabs of data and calculations. Recalculating continues to kick in over and over again.
    Is there any way to find out why recalc continues to happen when there is really no reason for anything to be recalculated?
    Should unfiltering cause a recalc?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Unfiltering (and filtering, and sorting) both trigger recalculation.
    There isn't an easy way around this

    When you say that recalculation continually kicks in, do you mean with any user intervention - or is it when you have done something ?

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Recalc seems to kick in whenever I do almost anything (or anything).
    There are a number of formulas, but it seems inordinately long -- like 30 seconds each time. Painful.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Although there are lots of reasons for slow recalculation, the usual cause is excessive use of the functions RAND, NOW, TODAY, OFFSET, CELL, INDIRECT and INFO as well as complex formulas using SUMIF, SUMPRODUCT and similar - and large array formulas.

    And there's some comprehensive guidance on improving calculation speed here: http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

    The guidance above includes lots of tips. and a very helpful section on how to find out which worksheets are causing slowness in recalculation.
    Last edited by MartinM; 2013-12-12 at 13:48.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Good info. I have a number of INDIRECTS that I'll have to adjust, I think.

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    In addition to Martin's advice, make sure you do not have any code written in the Worksheet_Change or Workbook_SheetChange event subroutines.

Posting Permissions

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