Sunday, July 8, 2012

SharePoint List Column Limits

There are limits in number of columns we can create in a SharePoint list. You may Get "Column Limit Exceeded" when You add a new column to a SharePoint List. This is because of the column limitations.

For SharePoint 2003/2007:
With Windows SharePoint Services, you can create the following numbers of each column type for each list or library:
  •     64 Single line of text and Choice (drop-down menu or radio buttons)
  •     31 Multiple lines of text and Choice (check boxes (allow multiple sections))
  •     32 Number and currency
  •     32 Hyperlink
  •     16 Date and time
  •     16 Lookup
  •     16 Yes/No
  •     8 Calculated
Refer this KB for the limitations on the maximum number of columns we can have:

The above applies to SharePoint 2007 as well, but This is not a hard limit.

For SharePoint 2010 lists Column limits:  
Refer this Technet article:

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...