1. Click on cell D12.
2. Click on the formula bar at the top of the screen as if you were going to edit the formula.
3. Hit enter. Excel will now actually compute the value like it is supposed to.
4. Highlight the tableaux rectangle (D12:K16) and hit ctrl+r then ctrl+d. Now copy/paste this tableaux for the pivots below it.
5. Repeat steps 1-4 for cells P12 and AC12.