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.
How to refresh a table in Numbers so that cells update.
It's supposed to do this automatically, but ... it's Apple.
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
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
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.
I too have never had numbers not recalculate when it was supposed to, upon a cell change or opening.
I hope the OP tells more of what they are doing.
Specifics? What's in your table?
To post a screenshot, shift-command-4, select area by dragging cross-hairs, release, start new post here and use the mountains-and-moon 'Image insertion' icon beneath the compose window to insert the screenshot image from the Desktop.
SG
How to refresh a table in Numbers so that cells update.