Posts Tagged ‘Large’

Large Operation Warning: Excel

Posted: September 12, 2013 by Theodoulus in Excel
Tags: ,

We generally see a “Warning Dialogue Box” like:

large operation warning

This is seen when we try to put a formula, value or formatting to a big range (many cells) at a time in Excel worksheet.
So the good part is, we can modify the number of cells for which the dialogue box gets popped-up. And how do we do this:

Simply, Open Excel File -> Goto Excel Options-> Goto Advanced Tab -> In Editing Options, we can find one option like highlighted below:

large operation warning Solution

 

 

We can set any number in the box given there (in Thousands).

Now, if we perform any calculation on the a bigger range than specified, the Warning will be popped-up.

Advertisements