Thank you
Is there a way to ony make this calculate when the sheet (where I use
now() ) is opened?

On Fri, 14 May 2010 10:51:05 +0800, "ozgrid.com"
wrote:

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.