It is a little hard to tell from your description but the one thing I would
want to know first is the numbers you are retrieving, are they populating
your spreadsheet with numbers or with text. You will be able to tell by
trying to format the cells (increase the number of decimals. If more decimals
show up you have a number, if not then you have text). Your formulas will
obviously not work if the values are text. This scenario would explain why
thing work after you enter and leve the formula bar because Excel will do an
automatic type conversion if the contents are numeric. Let me know. If this
is the case it is not too bad to fix...
--
HTH...

Jim Thomlinson


"John Soarz" wrote:

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