ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Limelight Media - ExcelTip.com Books > F1 Get the most out of Excel Formulas & Functions

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 04-27-2006, 04:41 AM
m26498130 m26498130 is offline
Registered User
 
Join Date: 27 Apr 2006
Posts: 3
m26498130 is on a distinguished road
Random Number not changed

Hi all,

Anyone know how to make the generated random number remain the same when we re-open the worksheet? Somebody once told me I could use Index Match function, but I have no idea how to implement it in order to solve this problem. Please help me out!

Thanks before,

Manny.
Reply With Quote
  #2  
Old 07-28-2006, 01:43 PM
teelim teelim is offline
Registered User
 
Join Date: 27 Jul 2006
Posts: 60
teelim is on a distinguished road
Will switching off "Auto-calculate" help?

Tools>Options>Calculations>Manual

__________________
TL

http://teelim.googlepages.com/
My page of "not so useful" spreadsheets
Reply With Quote
Reply

Bookmarks

New topics in F1 Get the most out of Excel Formulas & Functions


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 05:48 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0