If you click on click to 'datasheet view' .The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator

if you click on click to 'datasheet view' .The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.

 Cause:  By default the limit is 8 lookups per list for users.

  Background: While using farm admin account the  error is not coming "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator." But while using SharePoint user account including site collection owners this " error occurs.

 Resolution:  Each new lookup column requires an additional SQL join.  As the number of joins goes up it will have a  effect on performance.  By default the limit is 8 lookups per list.  As you have seen this limit does not apply to farm admins.  You can change the limit for other users in the Resource Throttling settings of the web application in Central Administration.  But making changes to the resource limit can impact performance.

·  Go to Central admin-> Application Management > Manage Web Application.

·   In the Web Application list, select the web application you need.

· Then go to General Settings > Resource Throttling.

                     

                            

·  In the Resource Throttling window, scroll down to List View Lookup Threshold and change the value to the number that suits your needs.

                   

· Click OK.

Issue will get Resolve. Please Comment if you need any Help!!!!