Post a few of the formulas that are not calculating automatically.
Could be you are using non-volatile functions and precedents are not being
changed.
Most UDF's won't update without a full calculate.
Browse through the Calculation Secrets at Charles Williams' site.
http://www.decisionmodels.com/calcsecrets.htm
Gord Dibben MS Excel MVP
On Thu, 22 Oct 2009 13:25:01 -0700, tmpotvin
wrote:
Good Afternoon,
We've had some complaints from some users who use a specific spreadsheet and
it's not calculating automatically. The local support teams have confirmed
that Excel is configured to calculate automatically, however, they are
advising that the users have to hit ctrl+alt+f9 in order to get things
working properly.
They've went through all settings and they are ok, so I was wondering what
else we can maybe do to get this working.
Thanks in advance for the help!!
Tina