Go back to the "Change built-in groups in the Ribbon" Page


Note: in the Download section on the example page you can download a file that
rebuild the Data tab, you can use the Custom UI Editor then to see/copy the XML


Name : GroupGetExternalData

<!-- Add Get External Data group -->
<group id="DupGetExternalData" label="Get External Data" 
		insertBeforeMso="GroupGetExternalData" > 
	<button idMso="GetExternalDataFromAccess" size="large" />
	<button idMso="GetExternalDataFromWeb" size="large" />
	<button idMso="GetExternalDataFromText" size="large" />
	<gallery idMso="GetExternalDataFromOtherSources" size="large" />
	<separator id="DG1" /> 
	<button idMso="GetExternalDataExistingConnections" size="large" />
</group> 

Name = GroupConnections

<!-- Add Connections group -->
<group id="DupConnections" label="Connections" 
		insertBeforeMso="GroupConnections" > 
	<splitButton idMso="RefreshAllMenu" size="large" />
	<button idMso="Connections" />
	<button idMso="DataRangeProperties" />
	<button idMso="EditLinks" />
</group> 

Name = GroupSortFilter

<!-- Add Sort & Filter group -->
<group id="DupSortFilter" label="Sort &amp;&amp; Filter" 
		insertBeforeMso="GroupSortFilter" >
	<button idMso="SortAscendingExcel" showLabel="false" />
	<button idMso="SortDescendingExcel" showLabel="false" />
	<button idMso="SortDialog" size="large" />
	<separator id="DS1" /> 
	<toggleButton idMso="Filter" size="large" />
	<button idMso="SortClear" />
	<button idMso="FilterReapply" />
	<button idMso="AdvancedFilterDialog" />
</group> 

Name = GroupDataTools

<!-- Add Data Tools Options group -->
<group id="DupDataTools" label="Data Tools" 
		insertBeforeMso="GroupDataTools" > 
	<button idMso="ConvertTextToTable" size="large" /> 
	<button idMso="RemoveDuplicates" size="large" /> 
	<splitButton idMso="DataValidationMenu" size="large" /> 
	<button idMso="Consolidate" size="large" /> 
	<menu idMso="WhatIfAnalysisMenu" size="large" /> 
</group> 

Name = GroupOutline

<!-- Add Outline group -->
<group id="DupOutline" label="Outline" insertBeforeMso="GroupOutline" > 
	<splitButton idMso="OutlineGroupMenu" size="large" /> 
	<splitButton idMso="OutlineUngroupMenu" size="large" /> 
	<button idMso="OutlineSubtotals" size="large" /> 
	<button idMso="OutlineShowDetail" /> 
	<button idMso="OutlineHideDetail" /> 

	<dialogBoxLauncher>
	<button  idMso="OutlineSettings" />           
	</dialogBoxLauncher>
</group>