Feedback by UserVoice

How can we improve Excel for Mac?

Allow Trace Precedents/Dependents) to work on protected sheet

If you protect a sheet, Trace Precedents/Dependents no longer works, even if you can see the formulas. This can be annoying if someone wants to see the calculation flow, but the author doesn't want anything changed.

Either completely disable formula tracing only if the formulas are also set to hidden or add another option to the Protect Sheet dialog to toggle this on or off.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brett Gaspers shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base