The lookup columns in a SharePoint list return empty fields when the list item count exceeds 1000 items in a Windows SharePoint Service 3.0 site

Article translations Article translations
Article ID: 971025 - View products that this article applies to.
Expand all | Collapse all


Consider the following scenario:
  • In a Windows SharePoint Service 3.0 site, you use a SharePoint list that has lookup columns. These lookup columns display content from another document library.
  • You have more than 1000 items in the SharePoint list, and each of these list items has unique permissions.
When the SharePoint list item count exceeds 1000 items, the lookup columns in the list do not retrieve data from the document library. Instead, they return empty fields.


To resolve this issue, apply the following update:
  • 971065 Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): May 13, 2009


To work around this issue, reset the permissions on list items to make them inherit permissions from the list root (parent). Also, make sure that the total count of list items that have unique permissions does not exceed 1000.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Article ID: 971025 - Last Review: July 14, 2009 - Revision: 2.0
  • Microsoft Windows SharePoint Services 3.0
kbfix kbqfe kbexpertiseinter kbsurveynew kbprb KB971025

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from