Microsoft KB Archive/928751
Article ID: 928751
Article Last Modified on 5/14/2007
- Microsoft Office SharePoint Server 2007
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.
This problem occurs because Excel Services only applies the default Sort Order for a site locale.
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:
- On your Office SharePoint Server 2007 site, click Site Actions, and then click Site Settings.
- Click Regional settings in the Site Administration column.
- Select a Locale from the Locale list, select the first Sort Order in the Sort Order list, and then click OK.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about Excel Services, visit the following Microsoft Developer Network (MSDN) Web site:
Additional query words: XL2007 Excel2007 MOSS2007 XLServices ExcelServices ECS EWR
Keywords: kbexpertisebeginner kbbug kbpubtypekc kbtshoot kbexpertiseinter kbprb KB928751