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

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.

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.

• You will be able to paste the dataset as a 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.

• You will get the 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.

• Press OK.

• 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.

• 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.

• 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.

• 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.

• 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

• [Fixed!] Cannot Copy Merged Cells in Excel
• [Fixed!] Paste Link Not Working in Excel
• [Fixed!] Copy and Paste Not Working Between Workbooks in Excel
• How to Copy Number Not Formula in Excel
• [Solved] Excel Copy Paste Loses Formatting
  
• [Fixed!] CTRL C Not Working in Excel

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