VBA & Macro Problems

How to Fix Excel Pasting an Image Instead of Copied Text

Steve K Oct 22, 2026 868 views

Question details

The user needs to resolve an issue where pasting copied text from any source results in an image being pasted into Excel.

How to Fix Excel Pasting an Image Instead of Copied Text

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying text from a web page or within Excel and pasting it into an Excel worksheet.
Observed behavior: Excel incorrectly pastes an image instead of the text that was just copied to the clipboard.

Before you start

Save your current workbook and clear your system clipboard history before modifying any macro settings to ensure you are starting from a clean state.

Solution 1Recommended

Disable or Correct Malfunctioning VBA Macros

This solution addresses the most common cause: a custom macro that incorrectly overrides the standard clipboard copy and paste commands.

If your Excel workbook contains custom VBA code, a recently modified macro that interacts with the clipboard can easily disrupt standard pasting behaviors, locking the clipboard to an image format.

Open the VBA Editor

Go to the 'Developer' tab on the Excel ribbon and click 'Visual Basic', or press ALT + F11 on your keyboard.

Locate Clipboard Macros

Look through the active modules and 'ThisWorkbook' objects for any macros related to copy, paste, or clipboard events.

Disable the Suspect Macro

Add an apostrophe (') at the beginning of the lines containing the problematic code to turn them into comments, or disable the macro entirely.

Test the Paste Function

Close the VBA Editor, copy a new text string, and paste it into a cell to verify the normal text pasting behavior has returned.

Disable or Correct Malfunctioning VBA Macros

Default Behavior Restored: Disabling the faulty macro will immediately restore Excel's default copy and paste functionality without needing to restart the application.

Solution 2

Clear the Office Clipboard

Sometimes the Office clipboard cache becomes stuck on an image item and fails to register newly copied text.

Free Microsoft Office alternative

Try WPS Office for a Bug-Free Spreadsheet Experience

If you frequently encounter macro glitches or clipboard issues in Microsoft Excel, WPS Office provides a highly compatible, lightweight, and free alternative. It supports major Office formats and ensures smooth data processing without unnecessary complications.

1. Download and Install WPS Office: Visit the official WPS website and download the free version for your operating system.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx or .xls files.
3. Work Without Interruptions: Enjoy a stable environment for all your copy, paste, and macro execution needs.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) and macro-enabled files.Lightweight architecture ensures fast loading and stable copy-paste performance.Familiar user interface requires no learning curve to switch.Built-in advanced data processing tools at no extra cost.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel clipboard frozen on an image?

This usually happens when a background application, a browser extension, or a faulty VBA macro interferes with the system clipboard, overriding the most recent text copy with a previously stored image format.

How do I safely test if a macro is causing my paste issues?

You can open Excel in Safe Mode by holding the 'Ctrl' key while launching the application. If the copy and paste function works correctly in Safe Mode, an add-in or a macro is likely the culprit.

Can web browser extensions affect Excel's paste function?

Yes, certain browser extensions or standalone clipboard managers can alter how text is copied to the system clipboard, causing it to be pasted as an image or HTML object in Excel. Try disabling recent extensions to see if it fixes the issue.

Excel & Data Problems