[Fixed!] Paste Special Not Working in Excel (4 Possible Solutions)

Get FREE Advanced Excel Exercises with Solutions!

We often need to paste special values or numbers or characters in Excel. Excel allows users to paste different types of data through a feature called Paste Special. However, for some issues, sometimes the paste special option does not work properly. In this article, we will show 4possible solutions when paste special is not working in Excel.

In this article, we will discuss 4 probable solutions to the problem when the paste special is not working properly in Excel. Firstly, we will enable the paste option by going to the Advanced option in Excel. Secondly, we will open the Excel file in safe mode to solve the problem. The last two problems are subjective. If someone is using a VBA code, then he/she needs to set the Application.EnableEvents feature to False in order to fix the problem. Finally, the users may need to close all browsers, if opened, to resolve the matter.


1. Using Advanced Option to Fix If Paste Special Function Is Not Working in Excel

It often happens that the paste option button is disabled. Excel has a way to enable it. In this method, we will use the Advanced option in Excel to fix the problem.

  • To begin with, select the File tab.

choosing file tab to address paste special not working in excel

  • Then, from the More options select Options.

Consequently, a prompt will be on the screen.

selecting options to address paste special not working in excel

  • From the prompt, first select the Advanced option.
  • Check the box stating Show Paste Options button when content is pasted under the Cut, copy, and paste section >> click OK.

applying advanced option to address paste special not working in excel

As a result, we will find that a different paste option is enabled.

Read More: Run Time Error 1004: PasteSpecial Method of Range Class Failed


2. Enabling Safe Mode

A safe mode operation of Excel is where we open Excel in such a way that it allows Excel to prevent any type of errors in operation. It also prevents Excel from opening add-ins. In this method, we will open Excel in safe mode to fix our problem.

  • Firstly, press Ctrl >> Upon pressing the button right-click on the file >> From the available options, select Open.

As a result, a prompt will appear on the screen.

  • Then, select Yes from the prompt.

enabling safe mode to address paste special not working in excel

  • After that, open Excel add-ins one by one and try to find the add-in that is causing the problem.
  • Consequently, we will see that all the paste options are available in the options.

Read More: Difference Between Paste and Paste Special in Excel


3. Setting Application.EnableEvents to False to Fix If Paste Special Function Is Not Working in Excel

This is a special method dedicated to the situations while we are adding a VBA code to our Excel file using the Developer tab. If we set the Application.EnableEvents to True then, while writing the code Excel will allow different events like copying cells or modifying data to happen which may temper our code. That in turn prevents the users from pasting properly. That is why we need to set it to False to avoid such problems.

Application.EnableEvents = False

Read More: PasteSpecial Method of Worksheet Class Failed


4. Closing Browsers to Fix If the Paste Special Function Is Not Working in Excel

Sometimes we need to open different tabs in browsers while performing any task in Excel. This may sometimes prevent us from using the paste special feature. So, just as a precaution, we may need to close the browsers while working in Excel just to avoid the problem.

Read More: How to Use Paste Special to Multiply Numbers in Excel


Download Practice Workbook

You can download the practice workbook here.


Conclusion

In this article, we have talked about 4 easy ways to resolve the problem when paste special is not working in Excel. These solutions will help users perform their tasks properly in Excel and avoid any unwanted disturbance.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Adnan Masruf
Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo