How to refresh a table in Numbers so that cells update.

How to refresh a table in Numbers so that cells update.


It's supposed to do this automatically, but ... it's Apple.

Posted on Mar 27, 2023 3:02 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 31, 2023 2:35 PM

as Badunit said, the only reason I know to force a recalculation is for random number generation. like RandBetween possibly.


I have had to do this from time to time and force the recalculation by making a single cell table with a checkbox

clicking the checkbox is a change and forces a recalculation of all cells.


Jason


4 replies
Question marked as Top-ranking reply

Mar 31, 2023 2:35 PM in response to Wrangle

as Badunit said, the only reason I know to force a recalculation is for random number generation. like RandBetween possibly.


I have had to do this from time to time and force the recalculation by making a single cell table with a checkbox

clicking the checkbox is a change and forces a recalculation of all cells.


Jason


Mar 27, 2023 8:59 PM in response to Wrangle

Tables update when the spreadsheet is opened and whenever a change is made to any of the tables. I have never seen it fail to do so. For tables that do things like generate a list of random numbers, a simple checkbox in a cell can be used to force a recalculation. Checking or unchecking it will cause a recalculation of all the RAND and RANDBETWEEN functions and update any NOW and TODAY functions.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to refresh a table in Numbers so that cells update.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.