Excel popup “The operation you are about to perform affects a large number of cells”

Excel popup “The operation you are about to perform affects a large number of cells”

Some times while coding you might encounter a popup saying “The operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. Are you sure you want to continue?” and further it say “Note: This operation will be performed automatically in 60 seconds if no response is received.” and there is a check box which says “Don’t show this again”.

Root Cause:

Most probably this warning popup comes when you are trying to perform bulk operations like Insert rows, Delete rows, Insert formula etc.

Solution:

Try to narrow down your operation range, split operation into chunks, try to write some scripts to accomplish the job.

Leave a Reply

Your email address will not be published. Required fields are marked *