Random Numbers Change?

[Les Coover]

MS Excel 2000

Used the function

=INT(RANDBETWEEN(1,5)

to generate a list of random numbers.
Protected the sheet and left the
the range the function is in
locked.

Other parts of the sheet
unlocked.

Why is it that when I enter data
in unlocked cells that the list
of random numbers changes.

I needed to protect my random
generated data from changes
so I copied it as values to
another range and locked that
range so no changes can be
entered.

But I was wondering why the
cells with

=INT(RANDBETWEEN(1,5)

in them change when I am entering
data in other areas of the sheet.

Thanks,

Les

 

[Harald Staff]

Hi Les

They are formulas. Formulas recalculate after cell entries, and they are not
disabled by cell protection.

HTH. Best wishes Harald

 

[Dave R.]

First, you don't need INT . Randbetween returns only integers.

It recalculates if you have automatic calculation turned on, which most
people do. Tools>options>calculations will let you set calculations to
manual, but I don't think you want to do that.

Best to either copy and paste them as values, or create some macro to create
random numbers within a certain range.