Validating excel spreadsheets


Please note that the video was made using Excel 2010, hence the specific menu and look will be for Excel 2010.

All documents as shown here are included in the package, and many more! The LIBs show how the FDA is using Excel in their own laboratories.

These documents are not available on FDA's website.

The package includes forms for effective and consistent implementation Validation and Use of Excel in Regulated Environments. Ludwig Huber The Package includes 5 FDA warning letters, 483's/ EIR's related to topics in the Package The package includes over 100 FDA and International Regulations and guidelines Here are just a few examples 21 CFR Part 11 and other regulations.

Excel Safe provides the technological controls to protect and secure Microsoft Excel spreadsheets, ensuring compliance with 21 CFR Part 11 in Gx P environments.

Note how Excel has used the Underscore for "Expensive_Cars". There are a couple of points that we should understand.

Normally, a Validation list cannot refer to a list from another Worksheet.

I’ll also show you a trick for quickly defining multiple Named Ranges very quickly, and explain how Data Validation in Excel can be easily bypassed – and what you can do about it.

I have divided the techniques into four different sections: In order to follow along with the video and article please download the Sample Workbook “Lists_Dropdowns_Data Validation.xlsx” by clicking here Note: the sample workbook has been tested on Excel 2010 (32-bit, English language version) and may or may not work in other versions of Excel.

All compliance features work automatically; no changes are required to your existing spreadsheets.

You must have an account to comment. Please register or login here!