Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Macro takes longer than expected to execute many individual copy and paste operations in Excel 2010 and later


View products that this article applies to.

Symptoms

Assume that you create a custom macro that executes many individual copy and paste operations in Microsoft Excel 2010 or a later version. When you run the macro, it takes longer than expected to complete the copy and paste operations.

↑ Back to the top


Resolution

To resolve this issue in Excel for Office 365, Excel 2019, Excel 2016 and Excel 2013, follow the steps in the "Registry key information" section.

To resolve this issue in Excel 2010, apply the following update and then follow the steps in the "Registry key information" section:

2817579 Description of the Office 2010 hotfix package (Mso-x-none.msp): August 13, 2013

Registry key information

Important
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.


The Active Clipboard is used during copy and paste operations and is integrated in Microsoft Office 2010 and later versions. After you install this hotfix package, you can follow these steps to turn off the Active Clipboard.

Note After you turn off the Active Clipboard, you cannot perform the actions that are described on the following Microsoft website:  
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\xx.0\Common\General\
    Note xx.0 in this registry path corresponds to the Excel version (16.0 = Excel 2016, 15.0 = Excel 2013, 14.0 = Excel 2010).
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type AcbControl, and then press Enter.
  5. In the Details pane, right-click AcbControl, and then click Modify.
  6. In the Value data box, type either decimal 2147483648 or hexadecimal 80000000, and then click OK.
  7. Exit Registry Editor.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbqfe, kbexpertisebeginner, kbsurveynew, kbbug, kbfix, kb

↑ Back to the top

Article Info
Article ID : 2817672
Revision : 5
Created on : 9/29/2018
Published on : 9/29/2018
Exists online : False
Views : 234