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:
- 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.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
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
