=RAND() in Word 2010 freezes PC

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

=RAND() in Word 2010 freezes PC

Post by Rudi »

In reference to this post about the RAND() function in Word.

NEWSFLASH

Be very careful about using the function in Word 2010. It does not insert the useful 9 sentences into a document referring to some changes/improvements in Word 2007, but in 2010, when using =RAND() in a blank page, it dumps the entire OFFICE HELP DIRECTORY. It creates several hundred pages of content that can cause lower end PC's to freeze up, and cause work to be lost.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
HansV
Administrator
Posts: 78493
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: =RAND() in Word 2010 freezes PC

Post by HansV »

What's the date? Oh...
Best wishes,
Hans

User avatar
John Gray
PlatinumLounger
Posts: 5408
Joined: 24 Jan 2010, 08:33
Location: A cathedral city in England

Re: =RAND() in Word 2010 freezes PC

Post by John Gray »

Rudi - Did you try =DOLLAR() or =POUND() ?
John Gray

"(or one of the team)" - how your appointment letter indicates you won't be seeing the Consultant...

User avatar
Leif
Administrator
Posts: 7209
Joined: 15 Jan 2010, 22:52
Location: Middle of England

Re: =RAND() in Word 2010 freezes PC

Post by Leif »

John Gray wrote:Rudi - Did you try =DOLLAR() or =POUND() ?
I think that only works if you have Exchange Server installed.
Leif

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: =RAND() in Word 2010 freezes PC

Post by Rudi »

John Gray wrote:Rudi - Did you try =DOLLAR() or =POUND() ?
Leif is right...I got error messages on my PC complaining that the Exchange Server was not up and running and that I'll have to make installments into some Swiss account before the DOLLAR() or POUND() functions would work. I'll have to make do with the CENTS() function for now as this only dumps about 1/4 of the help files and does not freeze my PC.

Thanks for the advice John and a perfect answer Leif!!
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
John Gray
PlatinumLounger
Posts: 5408
Joined: 24 Jan 2010, 08:33
Location: A cathedral city in England

Re: =RAND() in Word 2010 freezes PC

Post by John Gray »

Leif wrote:
John Gray wrote:Rudi - Did you try =DOLLAR() or =POUND() ?
I think that only works if you have Exchange Server installed.
Brilliant!
John Gray

"(or one of the team)" - how your appointment letter indicates you won't be seeing the Consultant...

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15628
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: =RAND() in Word 2010 freezes PC

Post by ChrisGreaves »

Rudi wrote:NEWSFLASH
In the trade we call this a Rudi Awakening.
There's nothing heavier than an empty water bottle

User avatar
Samantha
3StarLounger
Posts: 363
Joined: 24 Jan 2010, 07:19
Location: Spokane, WA

Re: =RAND() in Word 2010 freezes PC

Post by Samantha »

ChrisGreaves wrote:
Rudi wrote:NEWSFLASH
In the trade we call this a Rudi Awakening.
And which trade would that be, Chris? :wink:
Samantha

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15628
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: =RAND() in Word 2010 freezes PC

Post by ChrisGreaves »

Samantha wrote:And which trade would that be, Chris?
:ranton: Sorry about the typo :ranton:
:megashout: "tirade"
There's nothing heavier than an empty water bottle