![]() Whether you’ve set up a bunch of random-number cells to test what will happen when real data is entered, or intend to keep the random-number formula in place to interact with data you input later, it’s important to test the results of various possibilities in your random range. ![]() But you can’t specifically trigger a recalc of cells, so those containing random numbers (from the RAND or RANDBETWEEN function) are quite static. ![]() It’s unlikely your spreadsheets will be so complex that recalculation will slow things down and, in any case, there’s no way to turn off the automatic recalculation that occurs when you enter data. So, they turn off the automatic calculation feature and trigger it when they want the sheet refreshed.īut, back to Numbers. Longtime Excel users have another reason to need it: some multi-worksheet files are so complexly intertwined that the automatic recalculation of connected formulas every time you enter new data can slow things down.
0 Comments
Leave a Reply. |