recalculate NUMBERS sheet

recalculate NUMBERS sheet

iWork-OTHER, Mac OS X (10.6.8)

Posted on Feb 15, 2018 4:13 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 16, 2018 1:51 PM

The usual way to get it to recalculate, other than making changes to the spreadsheet, is to include a checkbox in a cell. Each time you check/uncheck it, the document recalculates. Typically this is only needed if you are using functions like NOW or RAND or RANDBETWEEN which will actually change each.

2 replies
Question marked as Top-ranking reply

Feb 16, 2018 1:51 PM in response to rossimages

The usual way to get it to recalculate, other than making changes to the spreadsheet, is to include a checkbox in a cell. Each time you check/uncheck it, the document recalculates. Typically this is only needed if you are using functions like NOW or RAND or RANDBETWEEN which will actually change each.

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.

recalculate NUMBERS sheet

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