{"id":7460,"date":"2017-02-21T11:02:10","date_gmt":"2017-02-21T18:02:10","guid":{"rendered":"https:\/\/www.zubairalexander.com\/stage\/?p=7460"},"modified":"2020-09-26T10:33:02","modified_gmt":"2020-09-26T17:33:02","slug":"export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016","status":"publish","type":"post","link":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/","title":{"rendered":"Export to Excel Not Working in SharePoint Online and SharePoint 2016"},"content":{"rendered":"<p style=\"margin: 0in; font-family: Calibri; font-size: 12.0pt;\"><button class=\"responsivevoice-button\" type=\"button\" title=\"ResponsiveVoice Tap to Start\/Stop Speech\" data-rvtts-action=\"speak\" data-rvtts-text=\"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won&#039;t work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1 Make sure that you are using 32-bit version of Internet Explorer. None of the other browsers (Microsoft Edge, Chrome, Firefox, Safari, etc.) support ActiveX controls and are officially not\u00a0fully supported by Microsoft to work with SharePoint, as I have pointed out in this article Web Browser Support for SharePoint Server 2016. Best Practice: As a best practice, remove the link for 64-bit Internet Explorer on your company computers to avoid users accidentally starting\u00a0that version. You can end up spending hours or perhaps days troubleshooting weird problems in SharePoint when the problem all this time was the 64-bit version of Internet Explorer. Problem #2 You receive an error To export a list, you must have a Microsoft SharePoint Foundation-compatible application. Solution #2 This error is likely\u00a0because you are running multiple versions of Microsoft Office on the same computer. For example, you may have installed Office 2016 but SharePoint Designer 2013. Because SharePoint Designer is really an Office component, you are running multiple versions of Office. Multiple versions of Office cause a lot of errors and perhaps it\u00a0will\u00a0be a good topic for a future article. The solution is to make sure you are running only one version of Office. In some cases, you may have to completely remove the multiple versions, reboot the computer and then install only one version. If you only have one version of Office installed on your computer, then install the Microsoft SharePoint Foundation Support. You can simply go to the Control Panel, select your Office installation, click Change and then repair your existing installation. On the Installation Options screen, enable Microsoft SharePoint Foundation Support from the list of Office programs. Problem #3 Exporting to Excel doesn&#039;t work when you are working with a Custom List. This is a known\u00a0issue in SharePoint. For that and other reasons, a lot of people avoid custom lists in SharePoint. Solution #3 The solution is to avoid special characters when working with custom lists. You may run into this problem whether you are using a\u00a0custom list or not. Avoid using special characters in the column names, such as #, @, %, etc. You may have to delete the column and recreate it without special characters before you can export the list to Excel. Best Practice: Do not use special characters when creating a new column and do not use spaces in the name when you create a new column. Create them without a space and without special characters, then go back into the column and change it to whatever you want. For example, create a column called FaxNo, then edit the column and change it to Fax # or Fax Number. As far as SharePoint is concerned, behind the scene it&#039;s name would always be FaxNo. Problem\u00a0#4 You have tried other solutions and are still not able to export a SharePoint list to Excel. Solution #4 Look at the add-ons in your browser and make sure that all Office and SharePoint related add-ons are enabled. In particular, make sure that the SharePoint Open Documents Class is enabled. This add-on is used for various SharePoint features. In Internet Explorer, go to Tools -greater than Manage add-ons and verify two things. First verify that the Microsoft Office and SharePoint add-ons are enabled. Then verify that the architecture column says\u00a032-bit. Problem #5 You receive the error An unexpected error has occurred. Changes to your data cannot be saved. You may encounter this error when you are using a non-supported browser, or when you are exporting a very large list with thousands of entries. Solution #5 Let&#039;s say you have 10,000 items in a list. Use the All Items view and change the view so it displays fewer items, e.g. 1,000 or 700, and then try to export the list. You may have to try different numbers to get this to work. Basically, you are exporting data in smaller bunches. Do you have other problems or solutions when exporting a SharePoint list to Excel that you would like to share with the readers? Copyright \u00a9 2017 SeattlePro Enterprises, LLC. All rights reserved.\" data-rvtts-voice=\"US English Male\"><svg class=\"rvtts-icon\" width=\"22\" height=\"22\" viewBox=\"0 0 22 22\" fill=\"currentColor\" aria-hidden=\"true\" focusable=\"false\"><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M11 0C4.92345 0 0 4.92345 0 11C0 13.2683 0.690345 15.3772 1.86621 17.1221L0.811724 21.0517L4.70345 20.0124C6.48621 21.2641 8.65586 22 11 22C17.0766 22 22 17.0766 22 11C22 4.92345 17.0766 0 11 0ZM3.99793 9.99862C3.99793 9.44483 4.44552 8.99724 4.99931 8.99724C5.5531 8.99724 6.00069 9.44483 6.00069 9.99862V12.0014C6.00069 12.5552 5.5531 13.0028 4.99931 13.0028C4.44552 13.0028 3.99793 12.5552 3.99793 12.0014V9.99862ZM8.99724 13.9966C8.99724 14.5503 8.54966 14.9979 7.99586 14.9979C7.44207 14.9979 6.99448 14.5503 6.99448 13.9966V7.99586C6.99448 7.44207 7.44207 6.99448 7.99586 6.99448C8.54966 6.99448 8.99724 7.44207 8.99724 7.99586V13.9966ZM12.0014 17.0007C12.0014 17.5545 11.5538 18.0021 11 18.0021C10.4462 18.0021 9.99862 17.5545 9.99862 17.0007V4.99931C9.99862 4.44552 10.4462 3.99793 11 3.99793C11.5538 3.99793 12.0014 4.44552 12.0014 4.99931V17.0007ZM14.9979 13.9966C14.9979 14.5503 14.5503 14.9979 13.9966 14.9979C13.4428 14.9979 12.9952 14.5503 12.9952 13.9966V7.99586C12.9952 7.44207 13.4428 6.99448 13.9966 6.99448C14.5503 6.99448 14.9979 7.44207 14.9979 7.99586V13.9966ZM18.0021 12.0014C18.0021 12.5552 17.5545 13.0028 17.0007 13.0028C16.4469 13.0028 15.9993 12.5552 15.9993 12.0014V9.99862C15.9993 9.44483 16.4469 8.99724 17.0007 8.99724C17.5545 8.99724 18.0021 9.44483 18.0021 9.99862V12.0014Z\"\/><\/svg><span class=\"responsivevoice-button__label\">Listen to Post<\/span><\/button><\/p>\n<p><em>Export to Exce<\/em>l is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won&#8217;t work. There are several reasons why this feature may not work. I have listed a few of them in this article.<\/p>\n<h4><strong>Problem #1<\/strong><\/h4>\n<p>You are using a non-32-bit Internet Explorer.<\/p>\n<p><strong>Solution #1<\/strong><br \/>\n<span style=\"background-color: #ffff99;\">Make sure that you are using 32-bit version of Internet Explorer. <\/span>None of the other browsers (Microsoft Edge, Chrome, Firefox, Safari, etc.) support ActiveX controls and are officially not\u00a0fully supported by Microsoft to work with SharePoint, as I have pointed out in this article <a href=\"https:\/\/www.zubairalexander.com\/blog\/web-browser-support-for-sharepoint-server-2016\/\">Web Browser Support for SharePoint Server 2016<\/a>.<\/p>\n<p><span style=\"color: #339966;\"><strong>Best Practice<\/strong>:<\/span> <em>As a best practice, remove the link for 64-bit Internet Explorer on your company computers to avoid users accidentally starting\u00a0that version. You can end up spending hours or perhaps days troubleshooting weird problems in SharePoint when the problem all this time was the 64-bit version of Internet Explorer.<\/em><\/p>\n<h4><strong>Problem #2<\/strong><\/h4>\n<p>You receive an error <em>To export a list, you must have a Microsoft SharePoint Foundation-compatible application<\/em>.<\/p>\n<p><a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPFoundation-Compatible-App.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7463\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPFoundation-Compatible-App.png\" alt=\"\" width=\"522\" height=\"143\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPFoundation-Compatible-App.png 522w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPFoundation-Compatible-App-300x82.png 300w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<h4><strong>Solution #2<\/strong><\/h4>\n<p>This error is likely\u00a0because you are running multiple versions of Microsoft Office on the same computer. For example, you may have installed Office 2016 but SharePoint Designer 2013. Because SharePoint Designer is really an Office component, you are running multiple versions of Office. Multiple versions of Office cause a lot of errors and perhaps it\u00a0will\u00a0be a good topic for a future article. The solution is to <span style=\"background-color: #ffff99;\">make sure you are running only one version of Office<\/span>. In some cases, you may have to completely remove the multiple versions, reboot the computer and then install only one version.<\/p>\n<p>If you only have one version of Office installed on your computer, then <span style=\"background-color: #ffff99;\">install the Microsoft SharePoint Foundation Support<\/span>. You can simply go to the Control Panel, select your Office installation, click Change and then repair your existing installation. On the Installation Options screen, enable Microsoft SharePoint Foundation Support from the list of Office programs.<\/p>\n<h4><strong>Problem #3<\/strong><\/h4>\n<p>Exporting to Excel doesn&#8217;t work when you are working with a Custom List. This is a known\u00a0issue in SharePoint. For that and other reasons, a lot of people avoid custom lists in SharePoint.<\/p>\n<p><strong>Solution #3<\/strong><\/p>\n<p>The solution is to <span style=\"background-color: #ffff99;\">avoid special characters when working with custom lists<\/span>. You may run into this problem whether you are using a\u00a0custom list or not. Avoid using special characters in the column names, such as #, @, %, etc. You may have to delete the column and recreate it without special characters before you can export the list to Excel.<\/p>\n<p><span style=\"color: #339966;\"><strong>Best Practice:<\/strong><\/span> <em>Do not use special characters when creating a new column and do not use spaces in the name when you create a new column. Create them without a space and without special characters, then go back into the column and change it to whatever you want. For example, create a column called FaxNo, then edit the column and change it to Fax # or Fax Number. As far as SharePoint is concerned, behind the scene it&#8217;s name would always be FaxNo.<\/em><\/p>\n<h4><strong>Problem\u00a0#4<\/strong><\/h4>\n<p>You have tried other solutions and are still not able to export a SharePoint list to Excel.<\/p>\n<h4><strong>Solution #4<\/strong><\/h4>\n<p>Look at the add-ons in your browser and <span style=\"background-color: #ffff99;\">make sure that all Office and SharePoint related add-ons are enabled<\/span>. In particular, make sure that the SharePoint Open Documents Class is enabled. This add-on is used for various SharePoint features. In Internet Explorer, go to Tools -&gt; Manage add-ons and verify two things. First verify that the Microsoft Office and SharePoint add-ons are enabled. Then verify that the architecture column says\u00a032-bit.<\/p>\n<p><a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPOpenDocuments-Class.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7464\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPOpenDocuments-Class.png\" alt=\"\" width=\"737\" height=\"170\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPOpenDocuments-Class.png 737w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SPOpenDocuments-Class-300x69.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/a><\/p>\n<h4><strong>Problem #5<\/strong><\/h4>\n<p>You receive the error <em>An unexpected error has occurred. Changes to your data cannot be saved. <\/em>You may encounter this error when you are using a non-supported browser, or when you are exporting a very large list with thousands of entries.<\/p>\n<p><a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/Data-cannot-be-saved.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7465\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/Data-cannot-be-saved.png\" alt=\"\" width=\"464\" height=\"117\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/Data-cannot-be-saved.png 464w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/Data-cannot-be-saved-300x76.png 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<h4><strong>Solution #5<\/strong><\/h4>\n<p>Let&#8217;s say you have 10,000 items in a list. Use the All Items view and <span style=\"background-color: #ffff99;\">change the view so it displays fewer items, e.g. 1,000 or 700, and then try to export the list<\/span>. You may have to try different numbers to get this to work. Basically, you are exporting data in smaller bunches.<\/p>\n<p>Do you have other problems or solutions when exporting a SharePoint list to Excel that you would like to share with the readers?<\/p>\n<hr \/>\n<p><span style=\"font-size: xx-small; font-family: Verdana;\">Copyright \u00a9 2017 SeattlePro Enterprises, LLC. All rights reserved.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won&#8217;t work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":11219,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[43,31,63,54,11],"tags":[],"class_list":["post-7460","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-microsoft-office","category-office-365","category-sharepoint","category-tips-tricks"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won&#039;t work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Zubair Alexander\"\/>\n\t<meta name=\"google-site-verification\" content=\"xUGSODobCBguuxTNOCWOCVwAIhfY39LLtYAQOmExYzw\" \/>\n\t<meta name=\"msvalidate.01\" content=\"65829CD0C3C810D64E58EA860413DB21\" \/>\n\t<meta name=\"keywords\" content=\"export to excel,office 365,sharepoint online,sharepoint on-premises\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Alexander&#039;s Blog | Sharing knowledge with the global IT community since November 1, 2004\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won&#039;t work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2004\/11\/AlexandersBlog_logo_590x590.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2004\/11\/AlexandersBlog_logo_590x590.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"590\" \/>\n\t\t<meta property=\"og:image:height\" content=\"590\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2017-02-21T18:02:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-26T17:33:02+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@zubairalexander\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won&#039;t work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@zubairalexander\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2004\/11\/AlexandersBlog_logo_590x590.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#article\",\"name\":\"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog\",\"headline\":\"Export to Excel Not Working in SharePoint Online and SharePoint 2016\",\"author\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/author\\\/sp_admin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/SP2016_logo_250x250.png\",\"width\":250,\"height\":250,\"caption\":\"SharePoint 2016\"},\"datePublished\":\"2017-02-21T11:02:10-08:00\",\"dateModified\":\"2020-09-26T10:33:02-07:00\",\"inLanguage\":\"en-US\",\"commentCount\":10,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#webpage\"},\"articleSection\":\"Articles, Microsoft Office, Office 365, SharePoint, Tips &#038; Tricks\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/category\\\/tips-tricks\\\/#listItem\",\"name\":\"Tips &#038; Tricks\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/category\\\/tips-tricks\\\/#listItem\",\"position\":2,\"name\":\"Tips &#038; Tricks\",\"item\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/category\\\/tips-tricks\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#listItem\",\"name\":\"Export to Excel Not Working in SharePoint Online and SharePoint 2016\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#listItem\",\"position\":3,\"name\":\"Export to Excel Not Working in SharePoint Online and SharePoint 2016\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/category\\\/tips-tricks\\\/#listItem\",\"name\":\"Tips &#038; Tricks\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/#organization\",\"name\":\"Alexander's Blog\",\"description\":\"Sharing knowledge with the global IT community since November 1, 2004\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/AlexandersBlog_logo_590x590.jpg\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#organizationLogo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/zubairalexander\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/zubairalexander\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/author\\\/sp_admin\\\/#author\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/author\\\/sp_admin\\\/\",\"name\":\"Zubair Alexander\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#webpage\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/\",\"name\":\"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog\",\"description\":\"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won't work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/author\\\/sp_admin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/author\\\/sp_admin\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/SP2016_logo_250x250.png\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#mainImage\",\"width\":250,\"height\":250,\"caption\":\"SharePoint 2016\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\\\/#mainImage\"},\"datePublished\":\"2017-02-21T11:02:10-08:00\",\"dateModified\":\"2020-09-26T10:33:02-07:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/\",\"name\":\"Alexander's Blog\",\"description\":\"Sharing knowledge with the global IT community since November 1, 2004\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.zubairalexander.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog","description":"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won't work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1","canonical_url":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/","robots":"max-image-preview:large","keywords":"export to excel,office 365,sharepoint online,sharepoint on-premises","webmasterTools":{"google-site-verification":"xUGSODobCBguuxTNOCWOCVwAIhfY39LLtYAQOmExYzw","msvalidate.01":"65829CD0C3C810D64E58EA860413DB21","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#article","name":"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog","headline":"Export to Excel Not Working in SharePoint Online and SharePoint 2016","author":{"@id":"https:\/\/www.zubairalexander.com\/blog\/author\/sp_admin\/#author"},"publisher":{"@id":"https:\/\/www.zubairalexander.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SP2016_logo_250x250.png","width":250,"height":250,"caption":"SharePoint 2016"},"datePublished":"2017-02-21T11:02:10-08:00","dateModified":"2020-09-26T10:33:02-07:00","inLanguage":"en-US","commentCount":10,"mainEntityOfPage":{"@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#webpage"},"isPartOf":{"@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#webpage"},"articleSection":"Articles, Microsoft Office, Office 365, SharePoint, Tips &#038; Tricks"},{"@type":"BreadcrumbList","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.zubairalexander.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog\/category\/tips-tricks\/#listItem","name":"Tips &#038; Tricks"}},{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog\/category\/tips-tricks\/#listItem","position":2,"name":"Tips &#038; Tricks","item":"https:\/\/www.zubairalexander.com\/blog\/category\/tips-tricks\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#listItem","name":"Export to Excel Not Working in SharePoint Online and SharePoint 2016"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#listItem","position":3,"name":"Export to Excel Not Working in SharePoint Online and SharePoint 2016","previousItem":{"@type":"ListItem","@id":"https:\/\/www.zubairalexander.com\/blog\/category\/tips-tricks\/#listItem","name":"Tips &#038; Tricks"}}]},{"@type":"Organization","@id":"https:\/\/www.zubairalexander.com\/blog\/#organization","name":"Alexander's Blog","description":"Sharing knowledge with the global IT community since November 1, 2004","url":"https:\/\/www.zubairalexander.com\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2020\/10\/AlexandersBlog_logo_590x590.jpg","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#organizationLogo"},"image":{"@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#organizationLogo"},"sameAs":["https:\/\/twitter.com\/zubairalexander","https:\/\/www.linkedin.com\/in\/zubairalexander"]},{"@type":"Person","@id":"https:\/\/www.zubairalexander.com\/blog\/author\/sp_admin\/#author","url":"https:\/\/www.zubairalexander.com\/blog\/author\/sp_admin\/","name":"Zubair Alexander"},{"@type":"WebPage","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#webpage","url":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/","name":"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog","description":"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won't work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.zubairalexander.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#breadcrumblist"},"author":{"@id":"https:\/\/www.zubairalexander.com\/blog\/author\/sp_admin\/#author"},"creator":{"@id":"https:\/\/www.zubairalexander.com\/blog\/author\/sp_admin\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SP2016_logo_250x250.png","@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#mainImage","width":250,"height":250,"caption":"SharePoint 2016"},"primaryImageOfPage":{"@id":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/#mainImage"},"datePublished":"2017-02-21T11:02:10-08:00","dateModified":"2020-09-26T10:33:02-07:00"},{"@type":"WebSite","@id":"https:\/\/www.zubairalexander.com\/blog\/#website","url":"https:\/\/www.zubairalexander.com\/blog\/","name":"Alexander's Blog","description":"Sharing knowledge with the global IT community since November 1, 2004","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.zubairalexander.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Alexander's Blog | Sharing knowledge with the global IT community since November 1, 2004","og:type":"article","og:title":"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog","og:description":"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won't work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1","og:url":"https:\/\/www.zubairalexander.com\/blog\/export-to-excel-not-working-in-sharepoint-online-and-sharepoint-2016\/","og:image":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2004\/11\/AlexandersBlog_logo_590x590.png","og:image:secure_url":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2004\/11\/AlexandersBlog_logo_590x590.png","og:image:width":590,"og:image:height":590,"article:published_time":"2017-02-21T18:02:10+00:00","article:modified_time":"2020-09-26T17:33:02+00:00","twitter:card":"summary_large_image","twitter:site":"@zubairalexander","twitter:title":"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | Alexander's Blog","twitter:description":"Export to Excel is a useful SharePoint feature. Once in a while you may run into a situation where the feature just won't work. There are several reasons why this feature may not work. I have listed a few of them in this article. Problem #1 You are using a non-32-bit Internet Explorer. Solution #1","twitter:creator":"@zubairalexander","twitter:image":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2004\/11\/AlexandersBlog_logo_590x590.png"},"aioseo_meta_data":{"post_id":"7460","title":"Export to Excel Not Working in SharePoint Online and SharePoint 2016 | #site_title","description":"","keywords":[{"label":"Export to Excel","value":"Export to Excel"},{"label":"office 365","value":"office 365"},{"label":"sharepoint online","value":"sharepoint online"},{"label":"sharepoint on-premises","value":"sharepoint on-premises"}],"keyphrases":null,"primary_term":null,"canonical_url":"","og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 04:12:09","updated":"2025-06-04 01:45:24","seo_analyzer_scan_date":null},"jetpack_featured_media_url":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2017\/02\/SP2016_logo_250x250.png","_links":{"self":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/7460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/comments?post=7460"}],"version-history":[{"count":0,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/7460\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media\/11219"}],"wp:attachment":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media?parent=7460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/categories?post=7460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/tags?post=7460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}