Thanks Sharad, but the problem is it's needs to retain the values without
having to re-calc the formula every time a user opens the sheet

"Sharad" wrote:

Try Pressing 'F9' key after the spread sheet is opened.
This calculates the sheet again.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!