I have a column with data that is linked from another sheet and is totaled at the bottom. If I insert a row and type in a value, the total doesn't reflect what I added. I have to go to the cell with the total and bring up error checking and click "include omitted cells". Is there a way that this can be done automatic?