Export to Excel is a helpful SharePoint function. From time to time you might run right into a state of affairs the place the function simply received’t work. There are a number of explanation why this function might not work. I’ve listed a couple of of them on this article.
Drawback #1
You might be utilizing a non-32-bit Web Explorer.
Resolution #1
Just be sure you are utilizing 32-bit model of Web Explorer. Not one of the different browsers (Microsoft Edge, Chrome, Firefox, Safari, and so forth.) help ActiveX controls and are formally not totally supported by Microsoft to work with SharePoint, as I’ve identified on this article Internet Browser Assist for SharePoint Server 2016.
Greatest Follow: As a greatest apply, take away the hyperlink for 64-bit Web Explorer in your firm computer systems to keep away from customers by chance beginning that model. You may find yourself spending hours or maybe days troubleshooting bizarre issues in SharePoint when the issue all this time was the 64-bit model of Web Explorer.
Drawback #2
You obtain an error To export a listing, you could have a Microsoft SharePoint Basis-compatible software.
Resolution #2
This error is probably going since you are working a number of variations of Microsoft Workplace on the identical laptop. For instance, you’ll have put in Workplace 2016 however SharePoint Designer 2013. As a result of SharePoint Designer is admittedly an Workplace part, you might be working a number of variations of Workplace. A number of variations of Workplace trigger quite a lot of errors and maybe it will be matter for a future article. The answer is to ensure you are working just one model of Workplace. In some circumstances, you’ll have to utterly take away the a number of variations, reboot the pc after which set up just one model.
In the event you solely have one model of Workplace put in in your laptop, then set up the Microsoft SharePoint Basis Assist. You may merely go to the Management Panel, choose your Workplace set up, click on Change after which restore your present set up. On the Set up Choices display, allow Microsoft SharePoint Basis Assist from the record of Workplace packages.
Drawback #3
Exporting to Excel doesn’t work when you find yourself working with a Customized Record. This can be a identified situation in SharePoint. For that and different causes, lots of people keep away from customized lists in SharePoint.
Resolution #3
The answer is to keep away from particular characters when working with customized lists. Chances are you’ll run into this drawback whether or not you might be utilizing a customized record or not. Keep away from utilizing particular characters within the column names, resembling #, @, %, and so forth. You might have to delete the column and recreate it with out particular characters earlier than you possibly can export the record to Excel.
Greatest Follow: Don’t use particular characters when creating a brand new column and don’t use areas within the title if you create a brand new column. Create them and not using a area and with out particular characters, then return into the column and alter it to no matter you need. For instance, create a column known as FaxNo, then edit the column and alter it to Fax # or Fax Quantity. So far as SharePoint is worried, behind the scene it’s title would all the time be FaxNo.
Drawback #4
You have got tried different options and are nonetheless not capable of export a SharePoint record to Excel.
Resolution #4
Have a look at the add-ons in your browser and ensure that all Workplace and SharePoint associated add-ons are enabled. Particularly, ensure that the SharePoint Open Paperwork Class is enabled. This add-on is used for numerous SharePoint options. In Web Explorer, go to Instruments -> Handle add-ons and confirm two issues. First confirm that the Microsoft Workplace and SharePoint add-ons are enabled. Then confirm that the structure column says 32-bit.
Drawback #5
You obtain the error An sudden error has occurred. Modifications to your knowledge can’t be saved. Chances are you’ll encounter this error when you find yourself utilizing a non-supported browser, or when you find yourself exporting a really massive record with hundreds of entries.
Resolution #5
Let’s say you have got 10,000 objects in a listing. Use the All Gadgets view and change the view so it shows fewer objects, e.g. 1,000 or 700, after which attempt to export the record. You might have to strive completely different numbers to get this to work. Mainly, you might be exporting knowledge in smaller bunches.
Do you have got different issues or options when exporting a SharePoint record to Excel that you just wish to share with the readers?
