I don't want to confuse you.  You can ignore the second part of the quote starting with "If you are going to ......"

The examples I gave in my post - TODAY( ), NOW( ), OFFSET( ) are volatile functions.  Do you have any?
"Volatile Functions

Volatile functions are simple functions that will recalculate each time a change of any sort occurs in any cell on any worksheet.  Most functions will only recalculate if a cell which they are referencing has changed.  Some of the most common volatile functions used are undoubtedly the NOW() and TODAY() functions.  If you are going to be using the result of these functions frequently throughout your spreadsheet, avoid the temptation of nesting these functions within other functions to get your desired result.  Instead, simply type the volatile function into a single cell on your spreadsheet and reference that cell from within other functions.  This alone can potentially cut down on the amount of volatile functions by hundreds, if not thousands at times."

Source:  http://www.ozgrid.com/News/GoodVsBadDesignSpeedUpEvents.htm

Please wait for the experts.  I am just curious if you have any volatile functions in your worksheet.

Epinn

"des" <alberyds@tiscali.co.uk> wrote in message news:96DB6993-E00D-47E5-BBAD-8B9F43ADC7D0@microsoft.com...
Hi Epinn i dont know what a volatile function is.