Apple Numbers won't stop calculating

Apple Numbers has been calculating for days now. How do I stop and/or find out what is causing it


MacBook Air 13″, macOS 14.6

Posted on Jan 4, 2025 2:01 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 5, 2025 2:13 AM

Stopping it:


Apple Menu > Force Quit... > Numbers may also work.


Finding the cause:


Lots of possible contributing factors, including these:

    • wide use of "volatile" functions (that recalculate with every change, e.g. OFFSET, INDIRECT, ROWS, NOW, RAND, RANDBETWEEN, and others)
    • large tables - Numbers usually can handle several thousand rows smoothly but unlike Excel is not designed to handle very large datasets
    • lots of apps besides Numbers open at the same time
    • aging Mac with insufficient memory


SG

2 replies
Question marked as Top-ranking reply

Jan 5, 2025 2:13 AM in response to gwhuggins9

Stopping it:


Apple Menu > Force Quit... > Numbers may also work.


Finding the cause:


Lots of possible contributing factors, including these:

    • wide use of "volatile" functions (that recalculate with every change, e.g. OFFSET, INDIRECT, ROWS, NOW, RAND, RANDBETWEEN, and others)
    • large tables - Numbers usually can handle several thousand rows smoothly but unlike Excel is not designed to handle very large datasets
    • lots of apps besides Numbers open at the same time
    • aging Mac with insufficient memory


SG

Jan 4, 2025 10:24 PM in response to gwhuggins9

Hopefully your spreadsheet has been saved BEFORE it started calculating - in that case you could try to restart the device you are using.

Otherwise and for more specific tips you would need to provide more specific information if that is an option for you (e.g. What kind of calculation is it? Are your device and software updated? Has anything else happened that could have caused this glitch?)

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.

Apple Numbers won't stop calculating

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