Excel - Control + V disabled when trying to paste to another workbook

Add-in Express™ Support Service
That's what is more important than anything else

Only registered users are allowed to subscribe.
Excel - Control + V disabled when trying to paste to another workbook

Posts: 2
Joined: 2017-09-04

I am curious as to why this is happening on our Excel add-in.

So, there is a line of code
Application.Calculation = XlCalculation.xlCalculationAutomatic;

This is causing issue to users pasting data to other workbook. Clipboard data is good. It's just that the Paste option from the right click context menu is disabled and control + V doesn't work.

Any idea?
Posted 27 Feb, 2018 03:29:20 Top
Andrei Smolin

Add-in Express team

Posts: 14453
Joined: 2006-05-11
Hello Rieky,

I can't reproduce the issue on new or saved workbooks in Excel 2016 Version 1803 (Build 9115.2007 Click-to-Run) 32bit; this is Office Insider.

private void adxRibbonButton1_OnClick(object sender, IRibbonControl control, bool pressed) {
    ExcelApp.Calculation = Excel.XlCalculation.xlCalculationAutomatic;

I start in the Automatic Calculation mode; I tried clicking the button above and switching to the Manual mode before clicking that button. The result is invariably the same.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 27 Feb, 2018 04:23:53 Top