Macro - Unable to create a report in excel

Copper Contributor

I am trying to create a Excel report from Quickbooks. It says turn on macro. I did, still no report. It also says accessibility unavailable

5 Replies

Hello@Kimjaffcoinccom 

I too am having issues exporting from Quickbooks since update.  Last week I could

export EFW2 forms to upload to the state and unemployment.  Now it tells me

that excel is incompatible and there errors are compile error in hidden module defaulreport

and then module 1.

 

Can anyone help me correct this?  It worked fine last week.  Quickbooks says it is microsoft

update that is not compatible.

@Kimjaffcoinccom 

Same issue since last Friday. 

I made numerous calls to QB support. This is a known issue. It appears that the last MS update is the culprit. QB suggested that I uninstall Excel and install 32 bit. This did not fix the problem. Microsoft needs to provide a fix to this issue.

@Kimjaffcoinccom I believe this is directly related to: https://answers.microsoft.com/en-us/msoffice/forum/all/recently-excel-2212-build-1592820216-has-been...

 

I was able to solve this by removing Office 365 from Installed Apps, and installing the ODT tool from https://support.microsoft.com/en-us/office/use-the-office-offline-installer-f0a85fe7-118f-41cb-a791-... , and running the following: 

 

Create a XML file called officeconfig.xml with the following content: 

 

<Configuration>
  <Add OfficeClientEdition="64"
       Channel="MonthlyEnterprise"
       Version="16.0.15831.20252">
    <Product ID="O365BusinessRetail">
      <Language ID="en-us" />
    </Product>
  </Add>
  <Updates Enabled="FALSE"/>  
</Configuration>

Then run the Run command and type: c:\odt\setup.exe /configure officeconfig.xml and click OK

This was the fix.  Thank you!!!  @mattseitzfinancial