The following message might be displayed in QuickBooks if the QuickBooks plugin in Excel isn’t supported by any report:
“QuickBooks doesn’t support updates for this type of report. Please review the help section for a list of supported reports.”
Many of the reports that are used in MS Excel can be exported by QuickBooks. With the help of a QuickBooks plugin, the reports will also update in Excel.
However, reports that don’t support the QuickBooks plugin have to be exported to Excel in the form of a new report every time the data needs to be updated.
If users try to refresh a worksheet and see the message quoted above, the report doesn’t provide support to the QuickBooks plugin or update functionality.
The reports that won’t update from QuickBooks or a plugin are provided below. If users seek to see updated versions of these reports in Excel, they must export the data in the form of a new report every time the updated data has to be viewed.
- UK Standard Balance Sheet
- UK Balance Sheet Detail
- UK Balance Sheet Summary
- UK Balance Sheet Prev Year Comparison
- Payroll Liablities (P32)
- VAT 100 Report
- Unassigned VAT Amounts Detail Report
- VAT Item Summary
- VAT Detail Report
- VAT Exception Report
- EC Sales List
- Reverse Charge List
Export Option for Reports CSV file
It might happen that the export options for Excel aren’t available (grayed out) in QuickBooks and the only available option is to export a comma separated values (.csv) file. This could be caused by the following:
- Excel hasn’t been exported on the computer
- Excel has been installed across a network
- There’s damage in the local installation of Excel
NOTE: Before trying to solve the problem, the following should be done:
- Users must have an updated version of QuickBooks. If users are unable to export to Excel despite having and updated QuickBooks, they should try repairing QuickBooks.
Repairing QuickBooks in Windows 7, 8, 8.1 and 10
NOTE:Users must not be confused by any reference to the Installation Wizard, which actually runs the repair.
- First, the computer must be restarted for closing any program blocking QuickBooks. Then, the company file must be backe up.
- Then, choose Start, followed by Control Panel. In Windows 8/8.1, first open Search in the Start menu and type “Control Panel” and then choose Control Panel in the results.
- Next, choose Programs And Features and Uninstall A Program if needed. If these options aren’t available choose Programs and then Program Features.
- Then, choose QuickBooks from the programs list and then Uninstall/Change. Then, choose Continue, followed by Next.
- Next, choose Repair, followed by Next. Once the repair is completed, select Finish and if there’s a prompt, the computer must be restarted.
- United States users must also download the current QuickBooks release and the current payroll tax table after opening QuickBooks.
During repair, an error message or “Files in Use” message might appear. If either message appears: users must choose Ignore (must reboot system) and then choose OK. Users might have to choose Ignore many times; the repair would continue.
If there’s no Ignore button, choose Close and once the Repair is completed, the computer must be rebooted.
- The problem could be resolved by installing a compatible MS Office version on the computer or running Detect And Repair for MS Office. If the latter doesn’t work, users must try uninstalling and reinstalling Excel.
Toggling the Windows User Account Control (UAC)
- First UAC must be turned off. To do this in Windows 7, 8 and 10, users must press the Windows Start button and then type “Control Panel” in the search box and then hit Enter.
- Next, select the View By drop-down menu and then choose Large Icons. Then, choose User Accounts, followed by Change User Account Control Settings. Now the slider must be moved to Never Notify, followed by choosing OK.
- For turning off UAC in Vista users must press the Windows Start button and then choose Control Panel. If it isn’t selected, users must select Classic View to the left section of the window. Next, users must double-click on User Accounts and then choose to Turn User Account Control on or off.
- Next, users must choose or clear UAC for protecting the computer and then select OK.
- Once the UAC setting are changed, the computer must be restarted. Then, QuickBooks must be restarted and a company file opened. Then, users must choose a report in Reports.
- In the chosen report, the Export button must be selected. This should make available all export options, including Excel.
If these solutions don’t fix the problem, contact our QuickBooks experts.
For any other help, please call our AccountingHub QuickBooks Technical Support Team at this toll-free number +1844-313-4856. The AccountingHub QuickBooks Tech Support helpdesk is available 24X7 to provide any QuickBooks-related assistance.