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
