[Fixed!]: Microsoft Excel Cannot Paste the Data as Picture

Get FREE Advanced Excel Exercises with Solutions!

In Microsoft Excel, we can paste data in several formats. However, sometimes the data pasting process in picture format doesn’t work correctly. In this article, we are going to show you 7 possible solutions when Microsoft Excel cannot paste the data as a picture error pops up. If you are also curious about it, follow us till the end.


Microsoft Excel Cannot Paste the Data as Picture: 7 Possible Solutions

When we try to copy a dataset and paste it as a picture, Microsoft Excel shows us a warning message which states that Excel is failed to paste the data as a picture. Now, we will show you the possible ways to solve this problem.

Microsoft Excel cannot paste


Solution 1: Modifying Excel Advance Option

In the first procedure, we are going to change the Excel Advance option to fix this problem. The steps of this method are given below:

📌 Steps:

  • First of all, select the File > Options option.

  • As a result, the Excel Options dialog box will appear.
  • Now, click on the Advanced tab.
  • After that, scroll down with your mouse and find the General section.
  • Then, uncheck the Ignore other applications that use Dynamic Data Exchange (DDE) option.
  • Finally, click OK.

Changing display feature to solve Microsoft Excel cannot paste the data as a picture

  • You will be able to paste the dataset as a picture.

Microsoft Excel cannot paste the data picture

Thus, our procedure works perfectly, and you can resolve the problem, as Microsoft Excel cannot paste the data as a picture.


Solution 2: Using Paste As Picture Option

To get a copy of a dataset as a picture, you can use the Paste as Picture option. This feature will help you to paste the dataset as an image. The steps of this method are given as follows:

📌 Steps:

  • First, select the range of cells B2:D14.
  • Now, press ‘Ctrl+C’ to copy the data.

  • Then, go to the sheet where you want to paste the data.
  • After that, right-click on your mouse, and from the Paste as Special arrow option, choose the Picture option.

Choosing Paste as Picture option

  • You will get the picture.

Microsoft Excel cannot paste the data picture

Therefore, we can say that our method works effectively, and we are able to paste the data as a picture in Microsoft Excel.


Solution 3: Clean Boot State

Cleaning the boot state is another way to solve the issue. The steps of this approach are given below:

📌 Steps:

  • At first, press Win + R button.

  • As a result, the Run window will appear.
  • Now, write down the following command in the empty box.

MSConfig

  • Press OK.

Applying MSConfig to clean boot for paste data as picture

  • Another dialog box called System Configuration will appear.
  • Then, in the General tab, from the Startup selection section, check the Selective startup option, and uncheck the Load startup items option.
  • Click Apply.
  • Finally, click OK.

Selecting suitable option to fix Microsoft Excel cannot paste the data as picture

  • You will be able to fix the problem.

Hence, our method works fruitfully, and we are able to fix the problem, which is Microsoft Excel cannot paste the data as a picture.


Solution 4: Applying Microsoft Excel’s Automatic Repair Feature

Microsoft Excel has an automatic repair feature, which can repair the problems of an Excel file and can resolve the pasting issue. The automatic repairing process is described below:

📌 Steps:

  • Firstly, launch Microsoft Excel on your device.
  • Now, click on the Open > Browse option.

Opening a new file from MS Excel

  • As a result, a small dialog box called Open will appear.
  • After that, select the file, and from the drop-down arrow of the Open option, choose the Open and Repair option.

Applying Open and Repair option to paste the data as image in Microsoft Excel

  • Your Excel file will be repaired, and you will be able to paste data as a picture.

So, we can say that we can solve the problem that Microsoft Excel can not paste the data as an image.

Read More: [Fixed]: Right Click Copy and Paste Not Working in Excel


Solution 5: Restart Microsoft Excel

It is the simplest way. If you are facing any problem in pasting a dataset as a picture, close the application by clicking on the Close button at the right top of the window. Then, relaunch the application on your device, and you will be able to solve the problem.


Solution 6: Installing Updated Version of Excel

This is the ultimate way. The problem which we discussed in our article is usually found in the earliest version of Excel. So, to not face such an issue, always try to update the Excel application. You can also uninstall your old version from your device and reinstall the updated version of Excel.


Solution 7: Modify Display Options for Excel Workbook Feature

Sometimes, we have to copy the data from a picture and paste the data into a file. This task also creates some trouble. The steps to resolve this issue are given as follows:

📌 Steps:

  • In the beginning, click on File and go to Options.

  • As a result, a small dialog box called Excel Options will appear.
  • After that, go to the Advanced option.
  • Now, scroll down with the mouse and find the Display section.
  • Then, check the ALL option from the For Objects, show section.
  • At last, click OK to close the dialog box.

Modify the display option

  • Your problem will be fixed.

Finally, we can say that our approach works successfully, and we are able to fix the issue called Microsoft Excel cannot paste the data as a picture.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to fix the issue, which is Microsoft Excel cannot paste the data as a picture. We mentioned the possible solutions to resolve this issue. Any of these may be applicable to your case. Yet, if know a better solution regarding this issue, feel free to share that with us.


Related Articles


<< Go Back to Copy-Paste Not Working | Copy Paste in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo