@Vs Bk  RE:I have updated my payroll files in all the versions I work on for my clients but still get error

That's odd, and others as well! I tried it here, using what I think is the latest W2 excel template, and didn't get a compile error.

What version of Excel are you using? Is it 32 bit or 64 bit (that might matter)?

If you'd like I can check out the version of the W-2 template file you have and see if it's different than mine and if it compiles for me. If interested, send me a request here along with the template, first put into a ZIP file: BRC Support Request

Note: The template is located in your QuickBooks programs files folder.  It is usually at C:\Program Files\Intuit\QuickBooks [version]\Components\Templates\State_W2.xlt

(or C:\Program Files (x86)\... for older QB versions.)