P
pkeegs
I have a worksheet which generates a random number between two base numbers
using the RANDBETWEEN Function. Whenever I close the sheet and reopen, the
workbook won't recognise the function. I go into the add-ins and check the
Analysis Toolpak option, reset my number and it works fine - until I open it
after closing. Again I have to go in and recheck the Analysis Toopak. Any
suggestions as to what is going on.
Regards - Peterk
using the RANDBETWEEN Function. Whenever I close the sheet and reopen, the
workbook won't recognise the function. I go into the add-ins and check the
Analysis Toolpak option, reset my number and it works fine - until I open it
after closing. Again I have to go in and recheck the Analysis Toopak. Any
suggestions as to what is going on.
Regards - Peterk