Trying to create the State W2 efile text file.
QB has generated an Excel file but Where do I find the "Add-Ins" tab to locate the QB Payroll State W2 Drop-down Menu to do the Interview? I did this last year but I forgot how to locate the "Add-Ins" in the Excel file.
Hello there, mh34102.
Here's how you can locate the Add-ins option in Excel file:
I'll be around if you need more help with QuickBooks. Thanks.
When you launch the feature from QB, Excel will open and you'll see a prompt to continue the process. Then you'll see the toolbar or Add-in tab menu.
OP: Trying to create the State W2 efile text file.
Intuit: Here's how you can locate the Add-ins option in Excel file:...
This in no way answers the question. When using the W-2 feature, finding Add-ins is not part of the process at all.
Good morning. I too am having difficulty creating a state w-2 file for uploading. I followed your instructions re: file, options, add-ins. There are 2 QBExcelReporterUpdate add-ins, but no instructions with regards to making them "active". Any suggestions, Thanks!!
Thank you for sharing the prompt you've received, @b401k1.
Creating a State W2 is my priotity, With that being said, allow me to walk you through activating the Microsoft Excel add-ins on your end.
If you can't locate the Add-Ins that you want to activate, there would be a need for you to install the Add-Ins. Once completed, you'll see the newly activated add-ins listed under Active Application Add-ins tab.
Keep me posted if you have other questions about creating and e-filling your State W2. I'd be happy to help you more and answer all your inquiries. Have a good one.
Though not in your specific steps, I did find the add-ins locstion. AT the bottom I saw a buttonthat said Excel Add-ins, I clicked GO. I get a dialogue box with Analysis ToolPak, Anaslysis ToolPak-VBA, Euro Currency Tools, and Solver Add0in. There is no mention of a State W-2 add-in. Where do I go to get it, how do I doewnlosd it to be sasccessed from this point? Again, Many thanks!!
Hello there, b401k1.
Thanks for getting back to us and letting me know about how the steps work out for you. Allow me to jump in and help you further.
Since you're unable to see the add-ins for the QuickBooks Payroll forms, you need to repair QuickBooks. This can help fix any program-related issues or errors.
Start by closing all the unnecessary programs interfering with QuickBooks, here's how:
To Repair QuickBooks:
Check out this article for more details:
You should now be able to create the State W-2. Don't hesitate to leave me a response below if you have questions with the process. I'll be around!
I am trying to create my W-2 state efile. When I click create state w-2 efile, QB opens excel and I get the following errors:
1. microsoft visual basic for applications "errors occurred during load" click ok then get this error
2. microsoft visual basic for applications "can't load or unload this object" click ok then it opens and excel removes unreadable content.
I have done this process for years. Last year I used the same microsoft & QB edition and didn't have these problems. Can anybody help?
Hello there, @Stacie2.
Thanks for dropping by the Community. I’m here to help you get around the error message when pulling up your state W-2s in QuickBooks Desktop.
It’s possible that the error is caused by QuickBooks latest update not being compatible with your existing Microsoft application. I’d suggest making sure you are up to date on the new Microsoft updates.
If you haven’t updated QuickBooks, do so and then create your state W-2s. Should you encounter the same error, please contact Microsoft for further assistance.
That should do it. Please give them a call and let me know how it goes. I’m looking forward to hearing from you soon.