Skip to main content
iecnecaspokane
Feb 19, 2018 6:20 PM UTC
Solved

Cannot export to Excel anymore with Quickbooks 2016 for MAC

Export to Excel is no longer an option when I choose File Export?  WHY ?

    H3lpMeRhondaAnswer
    Aug 18, 2018 4:38 PM UTC

    Hi,

      I just went into the QB Preferences in QB for Mac 2016 and switched the Reporting /Export Report As preferences away from "SYLK for Microsoft Excel 2004" to "XLSX for Microsoft Excel 2008 & 2011, Apple Numbers '09".

     

    Hope that helps!

    Rhonda

    View in thread

    16 replies

    lynda11_2
    lynda11_2
    Feb 19, 2018 7:15 PM UTC

    Not sure why.  But this is the last version for Mac.  Can you export to iif and then open in excel?  Or export to .csv?

    iecnecaspokaneAuthor
    Feb 27, 2018 4:09 PM UTC

    The options you see in the screen shot are the only options I have.  The lists to IIF let you choose from other lists in quickbooks, not the current report you are trying to export.  Our ability to export to Excel disappeared, and we really need that feature.   

    MrMojo
    May 17, 2018 9:02 PM UTC

    Have you tried exporting to .txt?

    Excel may be able to import the .txt file information but formatting will be required to clean things up.

     

    Can you also print the reports to 1 page wide, which is an option in the PC version?

     

    One would think that Intuit would streamline the QB file format so it's Compatible between the PC vs Mac version by now but it has Not!

     

    lr4
    May 22, 2018 8:25 PM UTC

    Why dont the chat people know this or the answer??????

    Worst customer service EVER

      ClayJ
      ClayJ
      May 23, 2018 6:24 PM UTC

      Hey there, @Ir4, @iecnecaspokane.


      I'd like to pass along some information that can potentially shed light on this issue you're encountering with exporting reports to Excel. I want to make sure your computer is compatible with the version of Excel you are using. I've attached a link to the system requirements for QuickBooks for Mac 2016 here: https://community.intuit.com/articles/1502399-system-requirements-for-quickbooks-2016-and-enterprise-solutions-16-0 . When you get a chance, please review this and verify that your system meets these requirements. If your system does meet the minimum system requirements for compatibility, you might have an issue with the installation of Excel, or potentially with the QuickBooks Installation. To verify that the issue doesn't lie with QuickBooks, I recommend performing a Clean Install. Here's how:

      Uninstall QuickBooks Desktop for Mac:

      • Close down QuickBooks.
      • From the Finder menu, click Go.
      • Choose Applications.
      • Click and drag the QuickBooks icon to the Trash.

      Remove QuickBooks PLIST files:

      Note: The PLIST files from the User folder as well as the System folder will need to be removed. Removing these PLIST files will change all preferences back to the default settings, which could cause the product to become unregistered.

      >User PLIST:

      • While on your desktop, from the Finder menu, select Go.
      • Hold down the Option key, then click on Library.
      • Open the Preferences folder
      • Locate the PLIST files with QuickBooks and your version in the name and move them to the Trash.
        Note: Delete everything containing “com.intuit.QuickBooks20XX”
      • Empty the Trash.

      >System PLIST:

      • From a new Finder window or the icon on the desktop, open the Macintosh HD.
      • Go to Library > Preferences folder.
      • Locate the PLIST files with QuickBooks and your version in the name and move them to the Trash.
        Note: Delete everything containing “com.intuit.QuickBooks20XX”
      • Empty the Trash.

      Once the above steps are completed, you will restart your computer and reinstall QuickBooks. I've attached the link for reinstalling QuickBooks for Mac here: https://community.intuit.com/articles/1502368-install-and-set-up-quickbooks-mac-desktop . If you are still having issues with exporting reports, I recommend searching for steps online to repair Excel or contact Microsoft directly for assistance. Let me know your outcome after trying these steps. I look forward to hearing back from you both.

      jdklein33
      Jun 4, 2018 5:24 PM UTC

      Export to Excel doesn't work on my Win 10/Office 365 Excel either. This is a recent decrement in feature because it worked in February of 2018 when I first built the spreadsheet model that I want to update. I was looking for answers and found the issue with Mac being discussed but wanted to point out that the export to Excel on PC is no longer an option (it is grayed out, only a .csv export is an option). This is a huge issue because I can no longer update my dependent Excel business analysis models. 

      H3lpMeRhondaAnswer
      Aug 18, 2018 4:38 PM UTC

      Hi,

        I just went into the QB Preferences in QB for Mac 2016 and switched the Reporting /Export Report As preferences away from "SYLK for Microsoft Excel 2004" to "XLSX for Microsoft Excel 2008 & 2011, Apple Numbers '09".

       

      Hope that helps!

      Rhonda

      CedarChest
      Sep 27, 2018 6:48 PM UTC

      I have had an issue with exporting into Excel for quite a few months.  I ended up changing from the XLSX for Microsoft Excel 2008 & 2011, Apple Numbers '09 to SYLK for Microsoft Excel 2004, which allowed me to keep exporting reports into Excel but there were a lot of issues where I would then have to copy and paste into a new workbook to be able to save the reports.  The "XLSX for Microsoft Excel 2008 & 2011, Apple Number's '09" is the one I should be using and was using for years, however it WILL NOT export any Aging Reports but will export other reports.  Does anyone know what is going on and how do I fix this WITHOUT re-installing QB?

       

      Thanks

       

      Melody

      Terms & ConditionsAccessibility statement