+ Post New Thread
Results 1 to 4 of 4
Educational Software Thread, RANDBETWEEN in MS Excel in Technical; Ok, in excel 2003 can anyone tell me why the function RANDBETWEEN doesn't work? I'm cutting and pasting from the ...
  1. #1
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    617
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    RANDBETWEEN in MS Excel

    Ok, in excel 2003 can anyone tell me why the function RANDBETWEEN doesn't work?

    I'm cutting and pasting from the help example into the spreadsheet and even that won't work. All I get is #NAME? in the cell. :x

    Oh, and I installed all the office updates.

    Thanks

  2. #2

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,287
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    Re: RANDBETWEEN in MS Excel

    Make sure the Analysis pack add-ins are installed. I think that the VBA one is the one needed but it may be reliant on the standard pack as well. Go to Tools>Add-Ins and see if the tick box is ticked for them

  3. #3
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    617
    Thank Post
    3
    Thanked 17 Times in 15 Posts
    Rep Power
    22

    Re: RANDBETWEEN in MS Excel

    Mr TechMonkey

    I would like to say THANKYOU VERY MUCH. You eased my increasingly BIG headache.

    Why the Hell is there not one scrap of info in the whole of office or on the support webiste that explains why that problem occurs, especially when it's such a simple fix?

    Anyway, not I can get on with creating my random passwords.

    TA

  4. #4

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,287
    Thank Post
    225
    Thanked 405 Times in 302 Posts
    Rep Power
    162

    Re: RANDBETWEEN in MS Excel

    Took us about 3 weeks to track that down for a teacher. Yep, all the documentations assumes that it is installed by default, all Office help does the same. I think we only managed to trace it because we found a tip to reinstall the pack if something goes wrong and that was when we foudn it wasn't actually ticked.

    Glad to be of help though

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  2. excel in explorer
    By Uraken in forum How do you do....it?
    Replies: 2
    Last Post: 18th October 2007, 02:07 PM
  3. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  4. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM
  5. Excel frustration
    By GrumbleDook in forum Windows
    Replies: 3
    Last Post: 24th August 2005, 10:01 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •