Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 905232 - Last Review: September 13, 2005 - Revision: 1.1
Some exported fields display a number sign (#) delimiter when you export a list to Excel 2002 from a Windows SharePoint Services Web site
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 "1;#User Name" 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 "=Title," the value of the calculated field appears as "string,#value."
This problem occurs because of a design limitation in Excel 2002 when you use Excel 2002 together with Windows SharePoint Services.
To work around this problem, use either of the following methods:
- Manually remove the unwanted delimiters and IDs.
- Upgrade to Microsoft Office 2003.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Office SharePoint Portal Server 2003
- Microsoft Windows SharePoint Services 2.0
- Microsoft Excel 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate