.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

MOSS 2007 - Excessive items in a List Lookup

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

Hello Community,

I have a list that uses a lookup.  The lookup list has over 7,000 items and is throwing an error -

This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000).

What are my options for correcting this issue?



Tom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award - Linked-In - SharePoint Gypsy

View Complete Post

More Related Resource Links

MOSS 2007: list column that lookup to multiple documents stored in doc library

Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

# string with cross site lookup field value of List in datasheet view in moss 2007

I am getting appended # code value with cross site lookup field value of List in datasheet view, and also i am getting this value while export to Spreadsheet. How to remove this value.....

# string with cross site lookup field value of List in datasheet view in moss 2007


I am getting appended # code value with cross site lookup field value of List in datasheet view. I dont want that hash coded value, i need actual value. Please provide me the solution.



Rajanikanth Rayala

MOSS 2007 This list or library contains a large number of items.


I have a library showing "This list or library contains a large number of items.".

The library contains only 1300 items.


1. Would the performance, e.g., upload files/change item properties, be affected?

2. Any way I can better organize the items?

3. I kown we can create folders in a library, how can I create subfolder? Or subfolder refers to Content Type?

4. Would create content type improves performance?


Many thanks.

Exporting MOSS 2007 List to Excel 2007

When doing the export, the columns "Item Type" and "Path" are automatically displayed in the sheet.  Is there anyway to suppress these fields from exporting automatically?  I'm sure this has already been asked before, but I couldn't find anything after much searching (perhaps I'm using the wrong keywords).  Any help would be greatly appreciated.

How to get a list of installed MOSS 2007 updates?

We have several problems with our MOSS 2007 installation and operation and since we found out that two identical sharepoint servers (production and test) that had same updates applied have different Search_DB databases (they have same name function with different number of parameters, for ex.) we have a single idea of what can be the cause: Somehow, windows update or other quirk, an update or hotfix got applied to one of the servers.  Strange thing is, noone of our employees seems to know, neither google seems to know, how do we exactly get a list of installed updates on the MOSS 2007 installation.   So, simple question: HOW? How do we get a complete list of changes (hotfixes, servicepacks, patches) done to an installation of MOSS?

How do I get the Sharepoint 2007 KPI to use the "Calculation using all list items in the view"

I have a custom SP list that contains a numeric column in the list and the view selected for the KPI. The option to calculate using all items in the view is grayed out.  Sometimes SP will let me create a KPI like this, then I go back to the webpart and the indicator has reverted back to just a simple count of the number of items in the list.  I want to use the "calculate all items" from a numeric column and have my KPI stay that way? Any thoughts?

Consume MOSS 2007 list to 2010

Hi all, My end goal is to display a list in SharePoint2010 .... but the list actually originates from SharePoint2007. I thought it could be as easy as creating BCS to the SP2007 list web service (/_vti_bin/Lists.asmx) but BCS has issues with the complex data types and based on other threads this isn't possible.  We've been able to create a data source to the web service and display the list contents on a custom aspx page, but this isn't exactly our end goal. Is there a best practice for this type of thing?  Or do we have to go down the path of creating a custom web part while consuming the web service directly or the SOAP data source we've created?+ Note: Migration is not an option at this point... integration is our current path. Any help is appreciated. Thanks, Eric

Reg Upgrading List of MOSS 2007 to InfoPath 2010

Hi, Actually right now there is Newform.aspx of the list in MOSS 2007 through which we are collecting the data from the user.Now our customer is planning to migrate the application to SharePoint 2010 so i just want to know so that can we get a easy support to implement in InfoPath 2010 compared to the list of MOSS 2007 Thanks & Regards, Sudheer

Upgrade List from MOSS 2007 to SP2010

Hi, I have a list in MOSS2007 and I want to save it as a template to use it in SharePoint 2010. But, the problem we can't use stp file in SP2010. So, did you have idea about creating wsp package in 2007 for existing List ? I have seen this article but it talk about Discussion List Feature. Thanks 

Is there a way to upload multiple files to a SharePoint List Item in MOSS 2007? I can not use Doc Li



Is there a way to upload multiple files to a SharePoint List Item in MOSS 2007? I can not use Doc Library because of the funcationality.

Thank you,



Is there any facility to auto archive List items In Sharepoint 2007 and 2010?

i work for a software company, Recently client gave us a requirement where he need a functionality to archive list items based on its retention period... so i just wanted to know that is there any facility in Sarepoint 2007 or 2010 where we can auto archive list items.Kindly provide some information on this. thank you.

Uploading Multiple Documents To a List Item in MOSS 2007


Is it possible to attach multiple files to a single item in a List Webpart. If So how?

We are using MOSS 2007 and the attachements will be word dorcuments.

List privileges temporarily disappear after installation auf MOSS 2007 August 2010 CU


Hi all,

after installing the August 2010 CU for our English Sharepoint 2007 farm I randomly have the list menu buttons "New" and "Settings" missing.

The farm consists of two frontend servers, one backend (all three W2003R2 x32) and a SQL 2005 x64 database, also running Windows server 2003.

This appears for all users, including the site administration account. Strangely, after about 10 .. 20 minutes, the buttons re-appear and everything works fine.

Since I installed the August 2010 CU two weeks ago, I have had three occurrences of this phenomenon. Sharepoint Event Logs show no error at the time. IISReset did not fix the issue, it just "went away" after a short time.

Did anybody else experience this issue? Does anybody have a hint where to look for errors here or what might cause this?


Many greetings,



Unable to use Managed Property mapped to Choice Dropdown list column in MOSS 2007


I have a choice list column containing dropdown values. I crawled the content source and created Managed Property to map it.

Also Configured Advanced Search webpart to display the property. But when I pick the property and perform search with values then no results are returned.

Can any one can help me out.?

Thanks in Advance.!

SharePoint List Search in Moss 2007






Is there anyway to search the specified sharepoint List in the current site in MOSS 2007?




Column to show count of attachments uploaded for each List item in MOSS 2007


We have two requirements:

First, we need a column which shows the count of attachments that are for uploaded each item, the list structure is like below:

No. Of Files Attached Title Category Description Owner
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend