Worksheet: Undesired Consolidation

Issue

You send a tagged drawing to Worksheet. When the worksheet is generated all the line items are consolidated by a part number regardless of the tags.

Solution

Review the Worksheet Consolidation Criteria Settings. These settings tell Worksheet which columns to consider when performing a consolidation. If a column is unchecked, its data will be ignored when considering whether a line item should be consolidated.

In Worksheet, go to the Tools menu and then choose Preferences.

1. Click the Common button.
   
   
2. Click the Consolidate Criteria button.
   
   
3. Click Select All to ensure all fields are selected.
   
   
4. Click the Ok button.
   
   
5. Click the Ok button on the preferences window.

Now close the Worksheet application and recreate the worksheet from the drawing. Items should no longer be consolidated that are tagged differently. Only line items 100% identical across all fields would be expected to be consolidated.