Microsoft KB Archive/945908

= Microsoft Dynamics CRM 3.0 creates an incorrectly formatted Excel Worksheet when you export data to a dynamics pivot table =

Article ID: 945908

Article Last Modified on 12/21/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-



Source: Microsoft Support

RAPID PUBLISHING
RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.



SYMPTOMS
When you use the Export to Excel function to export data to a dynamics pivot table, Microsoft Dynamics CRM 3.0 creates an incorrectly formatted Excel Worksheet. When you open the Excel Worksheet, you receive the following error message:

Problems came up in the following areas during load.

PivotTable

The file cannot be opened because of errors. Errors are listed in:

This problem occurs if some attributes that you export to the Excel Worksheet have the same display name.



CAUSE
This problem occurs because pivot tables cannot contain two fields that have the same display name as column headers. The field names that are exported to the pivot table must be unique.



RESOLUTION
To resolve this problem, make sure that the names of the fields that are exported to the pivot table are different. To do this, change one of the display names of the attributes that have the same display name.

For example, you have an Opportunity entity that has two attributes. Both attributes have the same display name. To change one of the display names of the attributes, follow these steps:
 * 1) Click Settings, click Customization, click Customize Entities, and then double-click Opportunity.
 * 2) In the Entities: Opportunity page, click Attributes.
 * 3) Click Display Name to sort the attribute list by using the display names.
 * 4) Find the attributes that have the same display name.
 * 5) Double-click one of the attributes.
 * 6) In the Attribute page, type a new name in the Display Name filed.
 * 7) Click Save and Close.
 * 8) In the Entities: Opportunity page, click Actions, and then click Publish.



DISCLAIMER
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Keywords: kberrmsg kbexpertiseadvanced kbtshoot kbprb kbnomt kbexpertisebeginner kbmbsmigrate kbexpertiseinter KB945908

-

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

© Microsoft Corporation. All rights reserved.