View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default RANDBETWEEN INSTALL

Hi,

The key here is that there is a bug in the Analysis Toolpak installation but
it is easy to overcome. After you have attached the Analysis Toolpak, close
Excel and reopen it.

Regarding using this feature. I am not of the opinion that you should avoid
it, instead if you are distributing it to others I suggest letting them know
to attach the Add-In or be prepared to be peppered by phone calls.

--
cheers,
Shane Devenshire


"ALee" wrote:


On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click OK.
If necessary, follow the instructions in the setup program.

I did the first two steps several times and still got #NAME.
So, I should do the third step, but HOW?ALee