locked
QuickBooks launching Excel 365 but it's not installed! RRS feed

  • General discussion

  • I have a client with Office 2013 installed and activated on Windows 10.  I've confirmed it is the only version of Office installed, but via Control Panel and with the Office Assistant.  However, when the user attempts to export a report to Excel from QuickBooks, Excel 365 comes up with a window to confirm the license.  Of course there is no license and the 2013 key does not work.  What's happening here?  I've uninstalled/reinstalled 2013 and reset the default apps with no change.  Any thought are appreciated.

    Thanks,
    Joe

    Tuesday, February 11, 2020 10:07 PM

All replies

  • Hi Joe,

    It seems that there is some Office 365 installation residue on the computer. 

    Please use ospp.vbs to check the Office related activation status on current computers. You can post the result here to help me analyze the issue for you:
    1.Open Command Prompt as an Administrator, 
    2.Type cscript "%ProgramFiles%\Microsoft Office\Office16\"ospp.vbs /dstatus   or cscript "%ProgramFiles(x86)%\Microsoft Office\Office16\"ospp.vbs /dstatus
    3. Press Enter

    Note: The opss.vbs script is located in the C:\Program Files\Microsoft Office\Office16 folder. If you installed the 32-bit version of Office on a 64-bit operating system, go to the C:\Program Files (x86)\Microsoft Office\Office16 folder. For Office 2016, Office 365 and Office 2019, the name of folder is Office16. For Office 2013, it is Office15.

    Please find the records related to Office 365 (O365), pay attention to find out “Last 5 characters of installed product key: XXXXX” then type cscript "%ProgramFiles%\Microsoft Office\Office16\"ospp.vbs /unpkey:XXXXX or cscript "%ProgramFiles(x86)%\Microsoft Office\Office16\"ospp.vbs /unpkey:XXXXX , press Enter. Then check if it works. 

    If you don't find any related records about Office 365, try to use Office 2013 version of ospp.vbs instead:

    cscript "%ProgramFiles%\Microsoft Office\Office15\"ospp.vbs /dstatus
    or
    cscript "%ProgramFiles(x86)%\Microsoft Office\Office15\"ospp.vbs /dstatus

    Uninstall the remained Office 365 product key with the following commands:

    cscript "%ProgramFiles%\Microsoft Office\Office15\"ospp.vbs /unpkey:XXXXX 
    or
    cscript "%ProgramFiles(x86)%\Microsoft Office\Office15\"ospp.vbs /unpkey:XXXXX 

    If the issue couldn’t be fixed by the method above, it’s recommend that you remove all Office products and then reinstall Office 2013. If the easy fix tool doesn't completely uninstall Office from your PC, you can manually uninstall Office. See: Manually uninstall Office.

    If the issue persists, since the issue is related to QuickBooks as well, it's recommended that you contact QuickBooks support for help.

    Hope it’s helpful. If you have any updates, please feel free to let us know.

    Best Regards,

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Wednesday, February 12, 2020 6:21 AM
  • Hi,

    I am checking the status of this issue. Do you have any update for it?

    If the replies are helpful to this question, please remember to mark them as answers. Your action would be helpful to other users who encounter the same issue and read this thread. Thanks for your understanding.

    Anything unclear or any questions, feel free to post them back to let us know. I will be glad to follow up and help you.

    Best Regards,

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, February 20, 2020 3:31 PM
  • Hi,

    This thread has been around for a long time. Please remember to mark the replies as answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 

    Thank you for understanding! If you have any questions, or updates, please feel free to let me know.

    Best Regards,

    Herb


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Monday, March 9, 2020 1:45 AM
  • Step 1: Update QuickBooks Desktop
    Go to the Reports menu and open any report on the list.
    Select the Excel button. All export options, including Excel, should be available.
    If you still can't export, move on to Step 2.

    Step 2: Check QuickBooks system requirements
    Each version of QuickBooks Desktop works with specific versions of Microsoft Office. Check the system requirements for your version of QuickBooks: 2017, 2018, 2019, 2020.

    If your version of Microsoft Office isn't compatible, you'll need to upgrade.

    If your version is compatible, move on to Step 3.

    Step 3 : Reinstall QuickBooks
    Microsoft Office and Excel need to be installed on your computer before you install QuickBooks. If you didn't install Microsoft Office first, uninstall and reinstall QuickBooks Desktop.

    When you're done, go back into QuickBooks and export a report. If you still can't, you may need to follow the steps from Microsoft to uninstall and reinstall Excel.

    Also, you can switch your QuickBooks setup to cloud. QuickBooks enterprise cloud can be your solution to this.
    Thursday, July 16, 2020 11:21 AM