'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Transfer Excel Quick Access Toolbar Customizations Between Computers
Question details
The user needs to transfer their customized Excel Quick Access Toolbar and Ribbon settings from one computer to another using the export/import feature.
- Product
- Microsoft Excel
- Device & OS
- Windows 11
- Scenario
- Migrating workspace preferences and toolbar setups to a new PC or another device.
- Observed behavior
- Importing the Customizations.exportedUI file completes without error but fails to visually update the Quick Access Toolbar, a bug frequently observed when using an Office Insider build.
Verify that both computers are running the standard release of Microsoft Office, as version discrepancies between standard and Insider builds can prevent customizations from applying correctly.
Use the Built-in Import/Export Feature in Excel Options
This is the standard and recommended method for transferring your Quick Access Toolbar and Ribbon configurations across different devices.
On the source computer, open Excel and navigate to File > Options > Quick Access Toolbar.
In the bottom right corner of the window, click on the 'Import/Export' button, select 'Export all customizations', and save the 'Excel Customizations.exportedUI' file to a USB drive or cloud folder.
On the destination computer, open Excel and go to File > Options > Quick Access Toolbar. Click 'Import/Export', choose 'Import customization file', and select the saved .exportedUI file.
Click 'Yes' when prompted to replace existing customizations, then click 'OK' to close the Excel Options window.
Troubleshoot Office Insider Build Compatibility
Address software bugs that prevent the Quick Access Toolbar from updating, specifically on Office Insider releases.
Experience a Stable and Customizable Workspace with WPS Office
Tired of dealing with bugs and import issues in Microsoft Office Insider builds? WPS Office offers a highly stable, lightweight, and free alternative with full compatibility for your Excel spreadsheets. Its intuitive interface makes customizing your workspace straightforward and hassle-free without unexpected software glitches.
Frequently Asked Questions
Where is the Excel Customizations.exportedUI file normally saved?
By default, Excel prompts you to save the file in your Documents folder, but you can choose any specific folder, USB drive, or cloud storage location during the export process. It does not need to remain in a specific system folder to function.
Can I transfer Quick Access Toolbar settings from Word to Excel?
No. Microsoft Office customization files are application-specific. You must export and import customizations separately for Word, Excel, and PowerPoint.
Why are some of my customized icons missing after importing to a new computer?
Icons may be missing if the imported customization includes specific macros or third-party add-ins that are not installed on the destination computer, or if the file paths for those add-in tools have changed.
