Saturday, June 18, 2011

How to Avoid Unauthorized Deletion of Microsoft Excel Files


1. Open your spreadsheet and click on the 'Tools' menu if you are using Microsoft Excel 2003. Choose 'Protection' and then choose 'Protect Sheet' from the menu. This will protect the entire sheet and prevent any changes from being made.
2. Click on the Review tab and then 'Changes' if you are using Office 2007. Click on 'Protect Sheet.' This will protect your Office 2007 spreadsheet from any unauthorized changes.
3. Click on 'Tools' and choose 'Protection' from your Excel 2003 spreadsheet. Choose 'Allow Users to Edit Ranges' from the menu if you want your users to be able to edit specific ranges. Specify the ranges that users will be allowed to change. This is a useful feature if you need to solicit additional information from your users but do not want to risk them accidentally changing any other numbers in your worksheet.
4. Click on the 'Review' tab and choose 'Changes' from the menu if you are working with an Excel 2007' worksheet. Choose 'Allow Users to Edit Ranges' and choose the ranges that users will have permission to change.

Blogger news