Report Offensive Message

I added the lock icon to the qat and locked the input fields in the table. But how do you get the formula totals to automatically update? Even F9 doesn't work. You have to physically click on the total and right mouse button, update. I want the totals to update automatically.