keep your excel formulas safe

Over at the Excel Community, we have just added the latest post in our Accountants' Guide series. This is the first of two posts that look at ways of stopping users trampling all over your formula cells and destroying the integrity of your spreadsheets. Starting with the reasons for locking some cells and not others, and the importance of principle 14 of the 20 Principles for Good Spreadsheet Practice, the post goes on to explain why all your cells probably start off locked and why cell locking does nothing until you decide to protect your worksheet.

If someone has ever overwritten one of your formula cells, or if you've ever accidentally overwritten one of your own formula cells, then this post might help avoid this happening in the future and possibly save you thousands of pounds.

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.

Anonymous