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

Method 1 – Modifying Excel Advance Option


  • Select the File > Options option.

  • The Excel Options dialog box will appear.
  • Click on the Advanced tab.
  • Scroll down with your mouse and find the General section.
  • Uncheck the Ignore other applications that use Dynamic Data Exchange (DDE) option.
  • 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

Microsoft Excel cannot paste the data as a picture.

Method 2 – Using Paste As Picture Option


  • Select the range of cells B2:D14.
  • Press ‘Ctrl+C’ to copy the data.

  • Go to the sheet where you want to paste the data.
  • Right-click on your mouse, and from the Paste as Special arrow option, choose the Picture option.

Choosing Paste as Picture option

  • Get the picture.

Microsoft Excel cannot paste the data picture

We were able to paste the data as a picture in Microsoft Excel.

Method 3 – Clean Boot State


  • Press Win + R button.

  • The Run window will appear.
  • Write down the following command in the empty box.


  • Press OK.

Applying MSConfig to clean boot for paste data as picture

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

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

  • You will be able to fix the problem.

Method 4 – Applying Microsoft Excel’s Automatic Repair Feature


  • Launch Microsoft Excel on your device.
  • Click on the Open > Browse option.

Opening a new file from MS Excel

  • A small dialog box called Open will appear.
  • 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 can paste data as a picture.

Method 5 – Restart Microsoft Excel

If you face any problem pasting a dataset as a picture, close the application by clicking the Close button at the top right of the window. Relaunch the application on your device, and you can solve the problem.

Method 6 – Installing Updated Version of Excel

The problem we discussed in our article is usually found in the earliest version of Excel. To avoid 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.

Method 7 – Modify Display Options for Excel Workbook Feature


  • Click on File and go to Options.

  • A small dialog box called Excel Options will appear.
  • Go to the Advanced option.
  • Scroll down with the mouse and find the Display section.
  • Check the ALL option from the For Objects, show section.
  • Click OK to close the dialog box.

Modify the display option


Download Practice Workbook

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

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
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