Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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.


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

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:

Copy and paste multiple items by using the Office Clipboard

  1. Click Start, click Run, type regedit in the Open box, and then click OK.

  2. Locate and then select the following registry subkey:


    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.


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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!