Sage Intelligence SubTotal circular references errors when using Dynamic Range Refresh function.

SUGGESTED

I am using SubTotals in a large financial report using Dynamic Ranges, when I refresh the report I receive Circular reference errors.  Note I manually fix the reference errors but they keep coming back when Refreshing the worksheet.  Any ideas?  

  • 0
    SUGGESTED

    When you create your subtotal, you need to input each dynamic range as it's own independent sum [use the excel function =SUM(H13:H16) and so on]. This is because the range will dynamically change, so if you capture the individual sum for that range and only that range, it will expand and contract appropriately. Therefore if I am doing a subtotal of everything above my subtotal cell, but it happens to contain 8 different dynamic ranges, my subtotal formula would be as follows:

    =SUM(H13:H16)+SUM(H17:H17)+SUM(H18:H18)+SUM(H19:H19)+SUM(H21:H21)+SUM(H23:H26)+SUM(H28:H32)+SUM(H34:H34)