Microsoft KB Archive/931294

= You cannot change the data format to the desired currency in a pivot diagram in Visio Professional 2007 =

Article ID: 931294

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Visio Professional 2007

-



SYMPTOMS
When you try to change the data format to the desired currency in a pivot diagram in Microsoft Office Visio Professional 2007, the currency format that you want is not available. This issue occurs when you try to edit a data graphic in a pivot diagram to change the data format of the currency.

For example, you open a pivot diagram that is connected to a Microsoft Office Excel data source. The Excel data source contains United States Dollar (USD) currency data. When you try to edit a data graphic to change the data format of the currency, the USD format is not available in the Format box within the Data Format dialog box.



CAUSE
This issue occurs when the current user locale setting does not match the desired currency format of the data in your drawing.

Note The current user locale setting is located in Regional and Language Options in Control Panel.



WORKAROUND
To work around this issue, change the current location on the Regional Options tab in Regional and Language Options in Control Panel to the country format that will be used in the pivot diagram.

In Windows Vista, change the Current Format box on the Formats tab in Regional and Language Options in Control Panel to the country format that will be used in the pivot diagram.

Additional query words: visio2007 visio2k7 visio12 vso2007 vso2k7 vso12

Keywords: kbtshoot kbpivottable kbprb kbexpertisebeginner KB931294

-

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

© Microsoft Corporation. All rights reserved.