I come across a problem, which I cannot see any way to cure, can you help?
I was creating an expenses workbook for traveling sales-persons, where the completed expense sheets would be forwarded to the office (via email) and the weekly totals would be added to a master sheet called expenses.
Making a dummy sheet (for data test) I put in the first line of figures and used rand() to generate the rest, and found this fault.
In reality every figure will be input manually, so the fault does not arise, but what causes the rand function to change values when data in an unrelated cell is typed in.
Try this as a test.
Open a blank Excel page (any version)
in any cell type in =rand()
now type a character (letter or number) or word into any other cell on that worksheet and the random number changes.
Any idea why?, and is there any way to stop it?