Actually those are the steps to run a report in quickbooks and then export it to Excel. What is not working is the "Summarize Payroll Data in Excel" drop down. It has not been working for a year now but QB has done nothing about it.
We're receiving reports that other users are getting an error as well,pipeman.
We would like to inform you that this has already been escalated to our engineering team. I’d encourage you to contact our phone agents and have them attach your case to INV-24874, so they can add your account information to the list of affected users. That way, our engineers can send you updates via email when they are available.
As a workaround, try running the report from previous quarters and then selecting Yes when asked to update helps pull up the data correct.
However, if that doesn't work clean install of QuickBooks and Excel are possible fixes. Once done, let's try to run Payroll Reports in Excel.
Click Reports at the top menu bar.
On the drop-down list, click Employees & Payroll then choose Summarize Data Payroll in Excel.
Click Enable Content.
Select Dates and click Get QuickBooks Data.
For more Excel-based reports, check out these resources: