Believe the status bar should show Calculate if the workbook is not
completely calculated.

try using Ctrl+Alt+Shift+F9 to force a recalc. (assume xl2002 or later).


--
Regards,
Tom Ogilvy

"TonyKA" wrote in message
...
Dear ALL,

I am currently working on a excel workbook which has reached 284 sheets
and
is approx. 34MB in size.

The problem I am having is that sheets which have formulas between them
are
not always updating. I Have the automatic calculation settings o.k etc so
i
do not think it is that.
If i eneter a new formula that formula works but to get old formulas to
work
I need to refresh the data i.e. copy paste the formula again for the old
formulas to update any changes from new data entered.

This creates a problem of that I can not trust the data derived from the
workbook as it would take days to check if all the relevant formulas have
updated automativcally or not.

Is there a limit to the number of calculations a work book can do ?


--
Thanks,
TKA