My standard list. Do look at 4 (don't skip the rest).

--
Kind regards,

Niek Otten


Cells not calculating (correctly)

Most frequent causes:

1. Calculation is set to Automatic. This may have happened unintentionally, for example by opening another workbook first.
Calculation is an Excel-wide setting; the first workbook opened determines the calculation mode, which then applies to all
open workbooks and workbooks that are opened later in that instance of Excel. It can be changed manually (again, for all open
workbooks):
ToolsOptionsCalculation tab, check Automatic.
2. There are User Defined Functions (UDFs) which access cells directly from within the function, that is, not via the
argument list. Then Excel is not aware of the need of recalculation. You can include Application.Volatile in the function, but
there is no guarantee this will always calculate cells in the correct sequence in all (future) versions of Excel. Really the best
way is to include all precedent cells in the argument list.
3. Excel version 5.0a (yes, very, very old!) has serious recalculation bugs, Excel 97 absolutely needs Service Pack 2 (SP2)
to calculate correctly.
4. Very, very rarely, Excel's dependency tree gets messed up. One way to rebuild it is to find and replace all "=" by "=",
for all sheets. Later versions of Excel rebuild by pressing CTRL+ALT+SHIFT+F9
5. For many calculation secrets, visit Charles William's site:
www.decisionmodels.com


"Gardfd" wrote in message ...
Looking to see if someone can help point me in the right direction with
determining why my spreadsheet (VERY large with a lot of ranges, variables)
is acting up. Up until recently the model worked perfect, recently I added
some model protection and user sign-on requirements, but don't have any
conflicts I'm can see.

The issue: Some of my ranges are not updating, it's like the model is not
recalculating or updating the ranges after each use. The user selects a
state from a dropdown box, the value 1 = Alabama, 2 = Arkansas, and so on,
the value is assigned to a named range, which drives pivot tables, the coping
of other ranges and so on. While doing some debugging, I noticed that the
named ranges are keeping the previous value.

Thanks for any help