formuls results won't update automatically (auto is turned on)
 

I have some spreadsheets that do not automatically update the formula results
when I make changes. The auto calculation is turned on. Is there anything
else I can do to fix this? Does anyone know why this would be occuring? Is
it perhaps spreadsheets that were calculated in old versions of excel? I use
Excel 2002. Any help would be appreciated.