|Edit: The Shift-Ctrl-F9 works fine! And at every OPEN refresh the cells in the xls and the ods file.|
manofcash wrote:Hey guys, thanks for all your hep with this problem; it is much appreciated. I will have to look at the randbetween formula and see about modifying it to get this to do an automatic recalc since this was originally set up in Excel which appears to have slightly different program parameters for recalc requirements.
Users browsing this forum: Villeroy and 22 guests