How to allow sorting in a protected worksheet?

C

curtc.

I have several worksheets with lookup formulas in most of the cells. Is their
a way to allow the resulting row data to be sorted? I want to protect the
worksheet from changes/deletions to the original formulas, and only allow for
the sorting of the data that is generated. Thank You.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Enabling Autofilter and Sorting in a Protected Sheet 2
FORMULAS PROTECTION IN EXCEL WORKSHEET 6
Sorting a Protected Worksheet 1
Allow Insert Rows in a protected worksheet 2
Can I protect the formulas in a Worksheet but allow data inputting 2
Trace dependants or Precedents on a protected sheet 1
Sorting protected worksheets 0

Top