Keyboard Maestro & Excel 365 Conflict

I’m currently running Keyboard Maestro version 8.1.1 and Excel 365 version 16.10. When I cut a column in Excel in preparation to insert the column into a new location:

  • Excel hangs (I get the spinning color wheel)
  • Excel shows “Not Responding” in Activity Monitor
  • Keyboard Maestro Engine shows “Not Responding” in Activity Monitor

But when Keyboard Maestro and Keyboard Maestro Engine are not running, I am able to cut columns in Excel and insert them into new locations.

Has anyone else experienced this problem? Any solutions? Thanks.

Sorry, I don't have that version of Excel, so I can't confirm/refute your experience. But I have not seen any other reports of this behavior.

Have you checked to see if a KM Macro has been triggered by your action in Excel?

To see the most recent macros (and other activity), open the KM Engine log:
GoTo menu Help > Open Logs Folder, or just open this file:
~/Library/Logs/Keyboard Maestro/Engine.log

At the bottom you will see the most recent activity:

I tried this, and it happened for the first cut. But then when I tried to debug it further, it didn’t happen again.

Excel seems to put PDF and image data on the clipboard for cuts, which is a bit ridiculous to do for every cut.

You can exclude Excel from the clipboard history in the Excluded applications preferences in Keyboard Maestro. Of course, then you’re working without a net as far as your clipboard goes.

1 Like

The hanging occurs even when I select Cut from the Edit menu. So I don’t think it is triggering a KM macro. But in regard to your log tip, this is what I see:

2018-03-07 02:07:19 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:10:40 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.html (108005926 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: public.rtf (134217728 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: dyn.ah62d4rv4gk81n65yru (192938044 - max is 100000000)
2018-03-07 02:11:12 Ignoring large clipboard flavor: com.apple.webarchive (108006264 - max is 100000000)

Why it’s worrying about Excel’s clipboard, resulting in a conflict, is beyond me. See next entry for the solution.

I excluded Excel from KM's clipboard history. And the problem has gone away. Thanks for the solution.

19 AM

1 Like

Its not a macro that is running, it is the Clipboard History facility.

Hi, I know this thread is from a year ago, but I have been trying to solve this issue for at least 2 years until now. I not only confirm the behavior but I can tell that that there quite a few people in Microsoft Office form Mac forums complaining about exactly this, so maybe something can be done in terms of either recommendation, tip, advice or a similar thing to keyboard maestro users.

It might sound stupid but after two years suffering a log of Excel problems (it hangs when the amount of rows to copy is huge) I have been doing copy paste for at least 2 minutes just for the shake of begin how "normal" it feels now.

Thanks for sharing. Could you please explicitly state what behavior you are confirming?

Excel is extremely slow when copying while having keyboard Maestro running. The first copy is quite long, depending on the amount of data, and Excel may crash or it can become unresponsive while the user watches the spinning wheel. Disabling Excel in the Keyboard Maestro clipboard settings makes everything backs to normal

I am not observing that behavior, running
Microsoft Excel 365 (16.28)
Keyboard Maestro 9.0.1
on macOS 10.14.5 (Mojave)

Copy in Excel is very fast, and even displaying the KM Clipboard Switcher is fast.
What versions are you running?

I am running version KBM 8.2.4 now, Office 16.28 too.

What macOS are you running?

Keyboard Maestro 9 has some features to mitigate the fact that Microsoft applications “promise” every kind of flavor under the son (dozens of images formats, PDF, web archives, etc). Keyboard Maestro’s clipboard history (like any clipboard history application) records the promised flavors, and this combination of “promising everything” and “recording everything” leads to poor performance.

Keyboard Maestro 9 ignores most image flavors if it finds some basic lossless ones.

But Excel still needs to load the whole PDF creation system (and other systems) on the first copy to live up to its promises.