Thank you for visiting the QuickBooks Community, MikelKent. I can see how important it is to file state W-2s in QuickBooks Desktop without errors so that you can manage your taxes. Following the instructions below, I'll make sure you can view or generate all Excel reports from QBDT. Then, pointed you to the right support team to further assist you in managing your W2.

To start with, I recommend following the steps outlined above in order to generate a State W2 and file this form. If the problem persists, I suggest contacting our QuickBooks Support Team. They have the tools to access your account in a secure environment and investigate why you are unable to generate state W2 and resolve this as soon as possible. You can follow the instructions provided by my colleague on how to reach them.

On the other hand, I recommend clicking Enable Editing on the Excel page. This is to ensure that you can open the file correctly. Then, make sure that your Excel is updated to the latest version when opening an exported file QBDT.

Lastly, you may refer to this article to view info on how you can pull up a specific report that gives you the total payroll wages, taxes, deductions, and contributions: Create a payroll summary report in QuickBooks.

Let me know in the comment section if you have other questions about filing W2 or any QuickBooks concerns. I’ll get back to answer them for you, MikelKent. Have a good one.