How do you ensure your workbook is accurate? One approach is to set up a structured error check sheet. My recent California CPA Magazine TBRG (May 2014) article discusses the ingredients needed to build a reliable error check sheet.
Here are the relevant links:
Article: Put Errors in Check
Sample workbook: Download Excel File