Last Updated: January 18, 2022
ISSUE
When an add-in or any extensibility or automation component calls into Excel Object Model to perform copy/paste operations in parallel instances of Excel, an unexpected error or crash may occur.
SCENARIO
You have an add-in that generates Excel reports by copying many rows/cells from a template. If you run two instances of Excel to generate multiple reports in parallel, Excel may error out or crash.
STATUS: WORKAROUND
-
If possible, use other APIs that do not interact with clipboard, such as get and set values using array. However, if formatting also needs copied, this may not be an option.
-
Avoid running the task that uses clipboard APIs in multiple Excel instances/processes in parallel.
More Resources
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.