I'm having a problem with my subtotal formula for some reason the cell is no longer refreshing. When I enter new data or filter the subtotals no longer adjust. I'm not sure when this started happening but now I need to manually refresh by selecting the cell and hitting enter. I've check the...