View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto Calculate Not Working in some Spreadsheets - Excel 2003

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