Subtotal dialog dropdowns unresponsive in Hebrew UI (RTL)

Roei Deri 0 Reputation points
2026-03-26T18:20:34.2166667+00:00

Hi everyone,

Has anyone encountered this issue?

In the Subtotal dialog, the dropdowns for options such as "At each change in" and "Use function" do not work at all when the display language is set to Hebrew, but work perfectly fine when the display language is switched to English.

Could this be an RTL-related bug, or am I missing something?

Thanks.

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

1 answer

Sort by: Newest
  1. AI answer

    2026-03-26T18:20:47.62+00:00

    This behavior matches known issues where certain features misbehave when a non‑English display language is used. In this case, it is very likely related to the Hebrew (RTL) UI rather than anything being misconfigured.

    To work around the problem when the Hebrew interface is active:

    1. Temporarily switch the Office display language to English when using the Subtotal dialog:
      • Open any Office app.
      • Go to File → Options → Language.
      • In Office display language, move English to the top or set it as the default.
      • Restart Excel, use the Subtotal dialog (the dropdowns should now work), then switch back to Hebrew if desired.
    2. If the issue persists even after language switching, or if this is impacting many users, collect details (Office build, Windows version, steps to reproduce) and open a support case so that the behavior can be tracked as a localization/RTL bug.

    The underlying pattern is similar to other non‑English/RTL issues where UI elements or calculations behave correctly in English but fail or disappear when another language is selected.


    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.