Editing a shared document that has some read-only capabiities

A

asmchi

We have an excel document where all of the columns, except for three, have
been locked down. We password protected the spreadsheet and then shared it.
Most cells are read only, but there are places that certain users need to
click and type into. Somehow the columns that were unlocked have become read
only. As I am the only one with a password and I have not opened the document
I'm not sure how this happened...

This type of scenario where a document needs to be shared but the integrity
of the data needs to remain occurs often and I've run out of Excel tricks.
How can we have a shared document with some read-only capabilities that can
also be selectively edited?
 

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

Make "File in use" message appear when 2 people open the a shared document in the same time 3
Page numbering with Merged Document and IF statements 1
Relevant user should see only his data 0
Shared Workbook opens as read-only 0
Files on shared folder only save as read only 1
Editing options disapear when document is changed to compatibility 4
Making a Excel file Read Only 2
How do I install Microsoft Equation 3.0 back to Office 365? 0

Top