looking to turn off formula and error checking

Question

Level 1

11 points

looking to turn off formula and error checking

Hi and top of the morning all. This one is not too big on my list, but anyway...

just wondering...

is there a way to temporarily disable automatic calculations in Apple’s Numbers? perhaps turn it off momentarily, to speed up edit cells, especially on larger sheets. I feel it will be cool to switch between modes. The only walk around I have so far, is to let it run through updating sheet and then going unto next cell. If you edit to many cells, you can really bug it down.

Oh, how about your remedies... that's welcome too.

thanks in anticipation to your replies.

MacBook Air, macOS 14.0

Posted on Nov 12, 2023 3:13 AM

Reply

Answer 1

Recycleur

Level 4

1,663 points

Nov 12, 2023 7:13 AM in response to Stvylife

Not possible.

See How to stop Apple Numbers from auto-calcu… - Apple Community for another answer on the same question.

Reply

Answer 2

Hal MacLean

Level 6

14,833 points

Nov 15, 2023 4:24 AM in response to Stvylife

The workaround I've seen on here (and used) is to copy the contents of the cells containing links, then use 'Paste and Preserve Style' into a new column. The content goes in without links.

Reply

Answer 3

Stvylife Author

Level 1

11 points

Nov 13, 2023 2:11 PM in response to Recycleur

I see... Acknowledged; and I'm pretty sure it is with reasons. So, it helps to plan accordingly since it's not possible. I'll take the advice about working with a new document , copying and pasting back in. Lastly, some mindfulness about efficiency could help too. For example using less of function that calculate all the time, perhaps using one instance of a function and then use references to it. For instance, I used to call the NOW() or today() functions a whole bunch.

Reply

looking to turn off formula and error checking

Similar questions