SharePoint Error - Unable to export data to Excel

When attempting to "Export to Excel" from the site, you might get an error that says:

"To export a list, you must have a Microsoft SharePoint Foundation-compatible application."

Windows 7

The fix for this is simple.  Please make sure that you are using the 32bit version of Internet Explorer and not the 64bit version.  In your start menu, the 64bit version of Internet Explorer is identified as Internet Explorer (64bit) whereas the 32bt version of Internet Explorer is simply displayed as Internet Explorer.  The 64bit version is the default for 64bit Windows 7 installations.

To select the 32bit version of Internet Explorer simply click on the start button and select the appropriate icon in start menu.

If you only see the 6bit version of Internet Explorer listed, click on the Start button and type Internet in the search field, and all versions of Internet Explorer should be listed.   Right-click on the the appropriate icon and Pin to Start Menu or Pin to Taskbar to have the icon easily available.

Windows 10

• Open up File Explore
• Navigate to C:\Program Files (x86)\Internet Explorer
• Right click in iexplorer.exe and select either Pin to Taskbar or Send to → Desktop (Create shortcut)

Now remember you MUST use this version of Internet Explorer when connecting to SharePoint