Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,560
    Thanks
    43
    Thanked 72 Times in 68 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
    1,091
    Thanks
    73
    Thanked 124 Times in 109 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,560
    Thanks
    43
    Thanked 72 Times in 68 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
    1,091
    Thanks
    73
    Thanked 124 Times in 109 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,560
    Thanks
    43
    Thanked 72 Times in 68 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,884
    Thanks
    147
    Thanked 733 Times in 665 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
  •