Why does paste special not work

Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. If you have Skype installed, see Text has incorrect format when using paste in Microsoft Office for more information. The Paste Special option can make the task of pasting text go more smoothly by letting you choose which formatting you want to keep source or destination or by stripping all the formatting and just pasting the text.

If you are having issues with the Paste Special option, continue on to the resolutions below. To enable the option, you need to set the value of the Application. EnableEvents property to False. Ensure that all instances of the web browsers that you use are closed and try to use the Paste Special option again. Paste special will not function if your web browser is causing the conflict. Third party Add-ins can cause a variety of issues, one of then being, conflicting with the Paste Special option.

To determine if an add-in is causing the issue:. If it is working, then that means one of the add-ons that you have is the root cause of your issue. You can try uninstalling add-ons one by one and check which one is causing the problem for you. Sometimes, Excel acts a little crazy when browser windows are open and you try to use Paste Special option.

In that case, simply close your browser instances IE, Chrome etc. Please drop a comment if one of the above listed methods worked for you. If the issue still persists, please tell us in comments, we would love to help you out. Table of Contents. Leave a Reply Cancel reply Your email address will not be published.