f9 recalulates
perhaps you should try copying the whole lot to a new work sheet.
i have seen this happen before and cant for the life of me remember how i cured it.