Since Intuit has been sitting on this for over a year, I decided to look into it a few months ago.

I found several issues with the template.  It took a couple of hours to figure out the issues, fix them, and test the fixes. 

Then I published a free fixed version of the Summarize Payroll template on our site here: Summarize Payroll Data In Excel « Big Red Consulting