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 dont have any
conflicts Im can see.

The issue: Some of my ranges are not updating, its 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