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
(thinking…)
Sign in with: facebook google
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
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base