I am trying to write the random formula ("=rand()") in an Excel cell…fetching this formula from the config file.
The formula is correctly written into the cell, but it is not “activated”.
When i click into the cell and hit enter, it works. Can someone help:
Can i do this without having to activate the cell?
If not, what is the most convenient way to do so (also considering that one may have to activate many many cells)?