Cannot export to Excel anymore with Quickbooks 2016 for MAC

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.   

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.

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