Microsoft KB Archive/905232

= Some exported fields display a number sign (#) delimiter when you export a list to Excel 2002 from a Windows SharePoint Services Web site =

Article ID: 905232

Article Last Modified on 9/13/2005

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003
 * Microsoft Windows SharePoint Services
 * Microsoft Excel 2002 Standard Edition

-





SYMPTOMS
When you export a list to Microsoft Excel 2002 from a Microsoft Windows SharePoint Services Web site, some exported fields display a number sign (#) delimiter.

For example, you may experience the following symptoms when this problem occurs:
 * The Assigned To field appears as &quot;1;#User Name&quot; in Excel 2002 after you export a list. Excel 2002 does not remove the ID. Additionally, a delimiter is added between the ID and the name.
 * If the exported list contains a calculated field, such as &quot;=Title,&quot; the value of the calculated field appears as &quot;string,#value.&quot;



CAUSE
This problem occurs because of a design limitation in Excel 2002 when you use Excel 2002 together with Windows SharePoint Services.



WORKAROUND
To work around this problem, use either of the following methods:
 * Manually remove the unwanted delimiters and IDs.
 * Upgrade to Microsoft Office 2003.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: datatype WSS SPS 2003 WSS2003 SPS2003 pound

Keywords: kbtshoot kbprb KB905232

-

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

© Microsoft Corporation. All rights reserved.