IBM Support

Microsoft Excel hangs ("Not Responding") when pasting multiple cells (for example a column), especially with Excel 2010

Troubleshooting


Problem

User launches Excel. User opens a spreadsheet (for example XLSX file). User selects several cells (for example a vertical column of 10 cells). User right-clicks on a different cell, and tries to click "paste". The Excel session seems to hang (pause). If the user tries to click anything they will see the cursor as an 'hourglass', the sheet turns white, and the words 'Not Responding' will appear at the top.

Symptom

Imagine a scenario where the user selects several cells in a column (for example 19), and then right-clicks and chooses "copy" (see below):


User then right clicks on a different cell and then tries to use the "paste special" or "paste" functionality, such as clicking on some of the icons shown below:


When moving the mouse over some of those options (e.g. the square pictures inside the 'Paste' options) at some point the entire Excel session will appear to hang.

During the above symptoms, the user may notice that the Excel sheet always has the following words shown at the bottom-left corner:

    Select destination and press ENTER or choose Paste

In addition, if the user launches Task Manager, they can see that EXCEL.EXE is using 100% of one CPU core.

This hanging may last several minutes.
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
10.1.1

Operating system(s):
Windows

Document number:
505541

Modified date:
08 May 2025

UID

swg21659193

Manage My Notification Subscriptions