'%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 Copy and Paste Failing When Live Preview is Enabled
Question details
Users are unable to use the copy and paste function in Microsoft Excel when the Live Preview feature is turned on, particularly after installing a recent update.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying and pasting data in a spreadsheet after an automatic Microsoft 365 update.
- Observed behavior
- The copy and paste function fails to execute. Traditional troubleshooting steps like Quick Repair or Online Repair do not resolve the issue, and the repair tool may fail to download entirely.
Verify your current Excel version and build number (e.g., version 2309) in the Account settings, and save all open workbooks before proceeding with safe mode tests or updates.
Test Excel in Safe Mode and Disable Conflicting Add-ins
Running Excel in Safe Mode helps determine if a third-party add-in is conflicting with the Live Preview feature during copy and paste operations.
If copy and paste works correctly in Safe Mode, the problem is likely caused by an active add-in. You will need to disable your add-ins one by one to isolate the culprit.
Press the Windows Key + R to open the Run dialog box. Type 'excel /safe' and press Enter.
Try copying and pasting data with Live Preview enabled. If it works, proceed to the next step.
Go to File > Options > Add-ins. At the bottom of the window, ensure 'Excel Add-ins' or 'COM Add-ins' is selected in the Manage dropdown and click 'Go'.
Uncheck all add-ins in the list and click OK. Restart Excel normally and re-enable them one by one to find the one causing the failure.
Temporarily Disable Live Preview
If the issue is a verified bug in your current Excel build, turning off Live Preview provides an immediate workaround so you can continue copying and pasting.
Report the Issue and Check for Office Updates
Since standard Office repairs often fail to fix version-specific bugs, installing the latest patch or reporting the exact build number to Microsoft is the best path to a permanent fix.
Try WPS Office for a Stable Spreadsheet Experience
If persistent Microsoft 365 update bugs are interrupting your workflow, WPS Office offers a highly compatible, stable, and lightweight alternative. Edit your spreadsheets flawlessly without copy and paste glitches.
- 1. Download the Software: Visit the official WPS Office website and download the free installer for your device.
- 2. Open Your Excel Files: Launch WPS Spreadsheets and open your existing .xlsx files directly. All your formatting and formulas will remain intact.
- 3. Work Without Interruptions: Enjoy smooth editing, copying, and pasting without worrying about Live Preview errors or update conflicts.
Frequently Asked Questions
What does Live Preview actually do in Excel?
Live Preview temporarily displays how your data will look if you apply a formatting change or paste data with specific rules, just by hovering over the option. While useful, it can sometimes cause performance issues or conflicts in specific software builds.
Why didn't Quick Repair or Online Repair fix my Excel?
Repair tools are designed to fix corrupted files within your current installation. If the issue is caused by a bug introduced in a recent Microsoft 365 update (like version 2309), repairing simply reinstalls the buggy version. A new patch or a settings workaround is required.
How can I find my exact Excel version and build number?
Open Excel, click on 'File', and select 'Account' at the bottom left. Under the 'Product Information' section on the right, you will see your version and build number listed next to the 'About Excel' button.
Will disabling Live Preview affect my spreadsheet data?
No. Disabling Live Preview only stops Excel from showing you temporary previews of formatting changes before you click them. It does not alter your actual data, formulas, or the ability to apply formatting permanently.
