I’ve had the same problem, and I found a workaround. Hope this helps, I know I did for me:
Reports>employees and payroll >summarize payroll data in Excel
click “yes” with the “We found a problem with some content in ...” message.
When the date option pops up click “options/settings” within that box. Next check the box beside of “customize employee information in PivotTables”.
Select the date desired, and get QuickBooks data. It will start to load and whenever you are able to, click the close repairs to QuickBooks data link.
Next a box will pop up that says “QuickBooks payroll work book-define with custom fields” and lists employees names. I just click OK, doing nothing.
after it loads into a spreadsheet, click OK and the information you need should be under the tab that says “calculated %”, last tab in my spreadsheet.
Select which item you want to look at it has a column for wagebase, the amount, and even the calculated percent.
Another way you can do this is to uncheck your protected view options in the trust center of Excel. Just do a search on how to open items up “not” in protected view in excel. If you do it this way I would suggest changing it back after you open up your QuickBooks file. You will get the same messages with the Quickbooks error but just check through it as usual And remember to always go to the “Calculator %” tab instead of the state wage listing tab.
Hope this helps!
