• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Subtotal formula not refreshing data

A

Abalayo

New Member
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 formula and I'm pretty sure it's correct(=SUBTOTAL(9, I2:I107). Anyone know why this is happening and how to fix it?
 
Hi,


Use =SUBTOTAL(109, I2:I107) or change the calculation from manual to automatic under formulas menu.


Thanks,

Suresh Kumar Sa
 
You must log in or register to reply here.
Back
Top