Is there a way to force recalculation?

Hi Robert,
Welcome to Numbers discussions.

To the best of my knowledge that feature isn't in Numbers. Yes that would be a nice feature for sure.

Please at the top of your screen to the right of the blue Apple click "Numbers". Now click "Provide Numbers Feedback". That will send your suggestion directly to the Numbers08 team.

Sincerely,
RicD

I think random numbers are recalculated every time a new calculation is performed. the whole sheet is recalculated. thus you could just type a number into a cell and it might force it to recalculate.

I know its not a true recalculate, but it works. I think.
I am at work and cannot check. I thought it did that to me before when I was creating some random data for another test I was making for someone.

hope this helps,
Jason

Hello

Alas, it doesn't update a table grabind datas from a "just sorted" auxiliary table.

But perhaps this oddity is not linked to a recalculate problem but to the huge bug made by the Numbers team.

When some cells containing formulas are sorted, the formulas are NOT self modified as they must be. They are just move with their original cells references.

All works as if they are treated as strings, not as cells references embedded in formulas.
Of course, a report is ready 😉

Yvan KOENIG (from FRANCE mercredi 19 septembre 2007 21:09:54)