macOS 13.3.1 (a) (22E772610a) and Numbers version 13.0 (7036.0.126) - all formulas in the table do not execute

Question

Level 1

8 points

macOS 13.3.1 (a) (22E772610a) and Numbers version 13.0 (7036.0.126) - all formulas in the table do not execute

I am experiencing this problem with a number of different formulas in different tables. It is usually, but not always, all the formulas in the same column. The formulas are identical except for their reference to a corresponding row in another table.

Double clicking the cell to bring up the formula bar and then clicking the green check to accept the formula as written triggers its execution and the correct value is then displayed. If the cell is copied and pasted back into itself this also triggers its execution and the correct value is then displayed.

When showing this bug to Apple support they will not accept what they can see happening as bug. They want to see the problem duplicated in another spreadsheet. This spreadsheet has 11 sheets and over 100 tables. Not something I'd attempt to recreate from scratch.

Is there any other avenue to report this bug? Is anyone else having it?

Posted on May 10, 2023 6:59 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

36,134 points

May 10, 2023 9:06 PM in response to maccustomer

That formula gives the expected result (3) here in a simple document.

A formula without confusing nested IFs also gives the expected result:

=IF(AND(N$1≤Input Week::$D$4,Weekly GHINs::O2≠""),N$1,"")

If you have to work with that many sheets and over 100 tables with lots of columns, then I am guessing Numbers may not be the right tool for your project.

I'm assuming, of course, that you have already taken the usual troubleshooting steps, including restarting your Mac.

SG

Reply

Answer 2

SGIII

Level 8

36,134 points

May 10, 2023 8:05 PM in response to maccustomer

It is very hard to tell from your general description. Can you give more specifics? What kinds of formulas? Some functions -- for example NOW() -- only recalculate when you make a change to the document. A screenshot would help.

SG

Reply

Answer 3

Badunit

Level 7

28,258 points

May 10, 2023 8:08 PM in response to maccustomer

Are you able to duplicate this problem in another document, not one that has 11 sheets and over 100 tables?

I have seen a specific use of INDIRECT formulas that sometimes would not update, but not others. It was when INDIRECT was referring to a non-existing table. When later the table was created, the formula did not reflect that it now referred to the newly created table.

Reply