Overview: This article explains how to fix error 'A worksheet much have an ID to create a key value' when inserting a reconciliation field for a custom workpaper.
Issue
Users may encounter the following error when starting a new blank or custom Excel sheet within a binder and attempting to add a reconciliation field in this new sheet:
Error: A worksheet must have an ID to create a key value.
Cause
The new sheet is not properly recognized by the Active Workpapers Addin.
Resolution
Right-click within the side pane and select 'Refresh' or 'Reload'.
Alternatively, close and reopen the binder, then try adding the reconciliation field again.
This will ensure that the added sheet is assigned a workpaper ID.
If issue persists, move/copy the sheet you are creating a reconciliation field for away from the excel workbook into a new excel workbook. Then close and reopen the binder and move the sheet back into your excel workbook.