CCH applies workbook structure protection to certain templates, particularly rolled-forward trial balances. This prevents DataSnipper v6 and later from creating the hidden sheets needed to store documentation. This article explains the issue, the available workarounds, and best practices.
Problem summary
DataSnipper v6 and later stores all documentation data in hidden worksheets to support Excel's Co-Authoring feature reliably. CCH workbook structure protection blocks the creation, deletion, or modification of sheets, including the hidden sheets DataSnipper needs. This affects rolled-forward trial balances and ledgers from CCH ProSystem fx and CCH Axcess.
Solutions
Option 1: Create a new workpaper (recommended for long-term use)
This is a one-time investment that ensures compatibility for future years.
Create a fresh trial balance in CCH instead of using the rolled-forward version.
Copy column headers, formulas, and formatting from the protected workpaper to the new one.
Import trial balance data or manually copy the necessary information.
Recreate any Snips and references from the original workpaper.
Cross-check with the original to verify nothing was missed.
Update your CCH engagement file with the new compatible workpaper.
Once created without structure protection, the workpaper will roll forward to subsequent years without compatibility issues.
Option 2: Use CCH's Publish feature (quick temporary fix)
Use CCH's publish functionality to export the protected workpaper to a standard Excel file.
Complete your documentation in the published Excel file using DataSnipper normally.
Copy your completed work back to the live CCH trial balance.
Best practices
For firms using CCH
Template management: create unprotected versions of commonly used CCH templates for DataSnipper compatibility.
Year-end planning: build time into your workflow for the one-time workpaper recreation before starting DataSnipper documentation.
Documentation standards: record which workpapers have been recreated to avoid duplication of effort across engagement teams.
For co-authoring environments
Ensure all team members use DataSnipper v6 or later for hidden sheet compatibility.
Store engagement files in OneDrive or SharePoint to enable Co-Authoring.
Use worksheet-level protection instead of workbook structure protection where possible — it provides security without blocking DataSnipper.
Next steps
Consider sharing your experience with Wolters Kluwer, as customer feedback helps prioritize improvements. You can contact their support team at support.cch.com.