I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error .
Below is a summary of the issue:
After selecting datasheet view :
"Cannot connect to the server at this time. You can continue working with this list, but some data may not be available." "Unable to retrieve all data."(At the bottom of data sheet view)
The item counts displays say 100 out of 14000 items.
Exporting List to excel is giving only 2000 records out of 14000 records.
Other Observations -
This is happening to only one list on the site .There are other lists in the site whose no. of records is equal to 8000 to 9000.They are working absolutely fine without any error.
Also, If I am saving this list as a template and creating another list with it ,then it is working absolutely fine with 14000 records,so the issue does not seem to be related with no. of records as the template list is working fine.
I have checked the Alternate access mapping setting ,its fine.
It should not be related to lookup or date field or any other column as the list created from it template is working fine with all these columns.
I checked below links also ,but doesn't seem to work in my case.