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.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
7 Possible Solutions If Microsoft Excel Cannot Paste the Data as Picture
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, titled as Microsoft Excel cannot paste the data as a picture.
Read More: [Fixed]: Right Click Copy and Paste Not Working in Excel (11 Solutions)
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.
Read More: How to Use Paste Special Command in Excel (5 Suitable Ways)
Similar Readings
- Excel Formula to Copy Cell Value from Another Sheet (4 Examples)
- Copy Rows from One Sheet to Another Based on Criteria in Excel
- How to Copy Only Visible Cells in Excel (4 Quick Ways)
- Excel Formula to Copy Cell Value to Another Cell
- How to Copy a Worksheet in Excel (5 Smart Ways)
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.
- 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.
Read More: Copy and Paste is Not Working in Excel (9 Reasons & Solutions)
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 entitles Microsoft Excel cannot paste the data as an image.
Read More: How to Paste From Clipboard to Excel Using VBA
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.
Read More: All Paste Options in Excel with Time Saving Shortcuts
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.
Don’t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!
Related Articles
- Copy Paste Vertical to Horizontal in Excel (2 Easy Ways)
- How to Copy Chart Format in Excel (3 Easy Ways)
- Copy from PDF to Excel and Keep Columns
- How to Copy Conditional Formatting Color to Another Cell in Excel
- Copy and Paste Exact Formatting in Excel (Quick 6 Methods)
- How to Copy the Same Value in Multiple Cells in Excel (4 Methods)
- Copy and Paste Without Changing the Format in Excel