Hello all,

I am hoping that you will be able to help me out because I am running out of
time and patience. Currently I have set up an excel spreadsheet that allows
users to use one main template and retrieve information from a back end
system into the template, then make adjustments to the current information
and from there upload the information back into the system.

The problem is that some of the formulas are not getting updated when some
numbers are changed. For some reason the only way that I can get the numbers
to update is when I go to the formula bar of that cell and then hit enter. I
have tried the F9 key to re-calculate, tried the calculate command using code
and have gotten nowhere. The files vary in size depening on how many Centres
each manager has. Usuually if a manager has 1-5 centres this is not an issue,
but for some reason when the number of sheets gets over that number I have
issues.

Any help would be greatly appreciated.

Thanks