Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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 "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."

↑ Back to the top

Cause

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

↑ Back to the top

Workaround

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

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: KB905232, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 905232
Revision : 2
Created on : 9/13/2005
Published on : 9/13/2005
Exists online : False
Views : 315