Microsoft KB Archive/928751

= The Sort Order is not applied when you select a new Sort Order that is not the default Sort Order for a site locale in Office SharePoint Server 2007 =

Article ID: 928751

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007

-



SYMPTOMS
You select a Sort Order for a site locale in the Microsoft Office SharePoint Server 2007 Regional Settings that differs from the default Sort Order. However, the new Sort Order is not applied to AutoFilters, Tables, or PivotTables.



CAUSE
This problem occurs because Excel Services only applies the default Sort Order for a site locale.



WORKAROUND
To work around this problem, make sure that you have the default Sort Order selected for a site locale. To do this, follow these steps:
 * 1) On your Office SharePoint Server 2007 site, click Site Actions, and then click Site Settings.
 * 2) Click Regional settings in the Site Administration column.
 * 3) Select a Locale from the Locale list, select the first Sort Order in the Sort Order list, and then click OK.



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



MORE INFORMATION
For more information about Excel Services, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms546696.aspx

Additional query words: XL2007 Excel2007 MOSS2007 XLServices ExcelServices ECS EWR

Keywords: kbexpertisebeginner kbbug kbpubtypekc kbtshoot kbexpertiseinter kbprb KB928751

-

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

© Microsoft Corporation. All rights reserved.