Microsoft KB Archive/816954

= Data that is not valid is synchronized to a SharePoint list in SharePoint Portal Server 2003 =

Article ID: 816954

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003
 * Microsoft Office Excel 2003
 * Microsoft Windows SharePoint Services

-



SYMPTOMS
When you synchronize a published Excel list to a SharePoint list, the synchronization process may insert numeric data that is outside the range defined for one or more columns in the SharePoint list. This numeric data is marked for data validation.



CAUSE
This issue occurs because the numeric values in Excel are not validated before they are synchronized with the columns of the SharePoint Web site. Excel cannot access the rules that SharePoint uses to validate data, and therefore it is possible to enter a value that is outside the validation range for the columns in the list.

Additionally, Excel cannot validate the data during the synchronization process to an existing published list on a SharePoint Web site. After the Excel list has been synchronized with its published version on the SharePoint Web site, the validation rules for the columns are then applied to the synchronized data by the SharePoint server.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: SPS STS XL2003 XL2002

Keywords: kbwebpublishing kbprb KB816954

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.