Question

Explain three different ways you protect your workbook...please guys!....

Answer 1

If you wish to learn Excel inside-out, I'd recommend to go over some key principles that will let you understand first and foremost whether a spreadsheet is the most appropriate tool for your job, and then how to turn it into a dynamic, shared piece of work.

When it comes to the latter, I'd encourage you to work collaboratively, share ownership and suggest review to maximize results and turn your Excel spreadsheets into powerful, recyclable tools, as opposed to one-off, isolated pieces of information. Especially if it takes so much effort to create or analyse a spreadsheet, why do it all over again next time? After nearly two years at Filtered, and being involved with spreadsheets every day, this is possibly the best advice I can give to anyone looking to improve their Microsoft Excel knowledge.

However, when many people are involved, also come risks. For example, it only takes a user who doesn’t understand how a spreadsheet works to overtype a key formula with a fixed number. And let's be honest - quite often you could overtype one of your own formula accidentally yourself. The result? Pretty simple. None will be able to rely on the spreadsheet giving the right answers.

To avoid this, I recommend you to lock certain cells in your spreadsheet to prevent them being changed. Logically, you would need to lock every single cell that contains a formula. However protecting an Excel workbook involves several steps.

First of all you have to make sure the right cells are locked and unlocked.Then, for locking to take effect, you have to individually protect each sheet of your workbook that contains at least one locked cell.Finally, to prevent users invalidating your spreadsheet, for instance by deleting or moving whole sheets, you need to protect the structure of the overall workbook.

Hope it helps you.....

Answer 2

First of all you have to make sure the right cells are locked and unlocked.

Then, for locking to take effect, you have to individually protect each sheet of your workbook that contains at least one locked cell.

Finally, to prevent users invalidating your spreadsheet, for instance by deleting or moving whole sheets, you need to protect the structure of the overall workbook.