'%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 Fix Excel Cannot Paste Errors by Resetting Office Registry Settings
Question details
The user is unable to paste content into Microsoft Excel after copying it from Word, and the issue continues even after reinstalling the Office suite.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to copy text or data from a Microsoft Word document and paste it into a Microsoft Excel spreadsheet.
- Observed behavior
- Excel refuses to accept the pasted content due to corrupted underlying Office settings, resulting in a persistent paste error that survives a software reinstallation.
Ensure you have completely closed all active Microsoft Office applications, including Word and Excel, and export a backup of your current Windows Registry before making any modifications.
Reset Office Settings via Registry Editor
Rename the Microsoft Office registry key to force Excel to generate fresh, uncorrupted configuration settings upon its next launch.
Corrupted configuration files stored in the Windows Registry can cause cross-application features, like the clipboard, to fail. By renaming the existing registry key, you safely archive the old settings while prompting the system to build new ones.
Verify that Microsoft Excel, Word, Outlook, and any other Office programs are completely closed on your computer.
Press the Windows key + R to open the Run dialog box. Type 'regedit' into the text field and press Enter to launch the Registry Editor.
In the left sidebar of the Registry Editor, navigate through the folder path: HKEY_CURRENT_USER > Software > Microsoft > Office.
Right-click the 'Office' folder in the directory tree and select 'Rename' from the context menu. Change the folder name to 'OfficeOld' and press Enter.
Close the Registry Editor and reopen Microsoft Excel. Try copying content from Word and pasting it into your spreadsheet to verify the error is resolved.
Switch to WPS Office for a Flawless Spreadsheet Experience
If Microsoft Excel continues to experience persistent paste errors or frustrating registry corruption, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free alternative that handles clipboard data seamlessly.
- 1. Download the Installer: Visit the official WPS website and click the download button to get the free installer.
- 2. Install WPS Office: Run the downloaded file and follow the simple on-screen instructions to install the suite.
- 3. Open and Edit Seamlessly: Launch WPS Spreadsheets to instantly open your existing .xlsx files and enjoy error-free editing.
Frequently Asked Questions
Why does Excel suddenly stop letting me paste data?
This issue is frequently caused by corrupted temporary files, conflicting third-party add-ins, or corrupted registry settings within the Microsoft Office suite. Resetting the Office registry key clears these problematic configurations.
Will renaming the Office registry key delete my Excel files?
No. Renaming the registry key to 'OfficeOld' only resets the application's interface preferences and background settings to their defaults. Your saved spreadsheets, documents, and personal files will remain completely untouched.
How do I back up my registry before making changes?
Open the Registry Editor, click 'File' in the top menu bar, and select 'Export'. Choose a safe location on your computer, ensure the 'Export range' at the bottom is set to 'All' or the specific branch you are editing, and click 'Save'.
What happens if I make a mistake while editing the registry?
Making an incorrect change in the registry can cause software malfunctions or system instability. If an error occurs, you can restore your previous working settings by double-clicking the backup .reg file you exported earlier to merge it back into the system.
