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?
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?
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)
*Community Hub is the new name for Sage City