sounds like you have a lot of items being recalculated each time.
Depending on what exactly is being recalculated, there are various things
you can do.
If this sheet is mostly data and most of the calculations are on other
sheets. you can make calculation be manual and set up a macro to calculate
just this sheet when anything is changed on this sheet.

You might break up the workbook into several smaller workbooks so that a
smaller section is being recalculated each time.
I have known people that the simplest thing to speed up calcs was to add
memory to the computer.
There also might be areas where you needed calculations to generate
something, but the answer is there now so that the calcs do not need to be
done again.
A lot of files work much better with some juditious copy and paste special
values.

"Jools" wrote:

If I enter new information onto a worksheet, the item is not included in the
totals box unless I leave the worksheet and then come back to it. I've tried
resetting the Tools - Options - Calculations to automatic - but it doesn't
help