[Fixed!] Paste Special Not Working in Excel (4 Possible 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 4 possible solutions when paste special is not working in Excel.

Table of Contents hide

Download Practice Workbook

4 Possible Solutions If Paste Special Function Is Not Working in Excel

1. Using Advanced Option

2. Enabling Safe Mode

3. Setting Application.EnableEvents to False

4. Closing Browsers

Conclusion

Download Practice Workbook

You can download the practice workbook here.

Paste Special Not Working.xlsx

4 Possible Solutions If Paste Special Function 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

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.

Steps:

To begin with, select the File tab.

Then, from the More options select Options.
Consequently, a prompt will be on the screen.

From the prompt, first select the Advanced option.
Then, check the box stating ‘Show Paste Options button when content is pasted’ under the Cut, copy, and paste section.
Finally, click OK.

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

Similar Readings

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 of operation. It also prevents Excel from opening add-ins. In this method, we will open Excel in safe mode to fix our problem.

Steps:

Firstly, press Ctrl.
Then, 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.

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.

3. Setting Application.EnableEvents to False

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 to paste properly. That is why we need to set it to False to avoid such problems.

Application.EnableEvents = False

4. Closing Browsers

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.

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 to perform their task properly in Excel and avoid any unwanted disturbance.