Protect Worksheet to share with older versions of excel
 

Can you protect a sheet and workbook so that rows, columns and formulas
cannot be changed, but others can add data (filling cells with data), but
still have users with an older version of Excel be able to access them?

Protect Worksheet to share with older versions of excel
 

Yes, you can protect individual cells within a Worksheet whilst leaving other
cells within the same Worksheet open for amendment.

If my comments have helped please hit Yes.

Thanks.

"VIPone" wrote:

Can you protect a sheet and workbook so that rows, columns and formulas
cannot be changed, but others can add data (filling cells with data), but
still have users with an older version of Excel be able to access them?

Protect Worksheet to share with older versions of excel
 

Hi,
Highlight the cells you want to let users enter information, right click on
the mouse,
format cells, Protection, uncheck Locked, then protect the worksheet

if this helps please click yes thanks

"VIPone" wrote:

Can you protect a sheet and workbook so that rows, columns and formulas
cannot be changed, but others can add data (filling cells with data), but
still have users with an older version of Excel be able to access them?