When you try to add a subtotal within a cell in Quickbooks Statement Writer* (QSW), the action is not allowed.
Excel returns this message:
The cell or chart you are trying to change is protected and therefore read-only.
All cells are locked and password protected in QSW, so they can only be changed by the integrated module. However, it is possible to create a report with as many customizations as necessary.
There are two ways to add a subtotal: by adding a row or by adding a column.
Option 1: Add a row
When you insert a row within the protected area, the protection is not applied to the inserted line. This allows you to enter text or create formulas within the protected area.
Note: If you need help with formulas, review examples for MS Excel.
Option 2: Insert a column
The following steps create an entire unprotected column and map data into that column.
The new column will continue to refresh with data from QuickBooks because its data is drawn directly from QuickBooks through the created formula.
Caution: Any changes made to this column and the cells populated with QuickBooks data can change the formula's results. Be sure to keep the first formula intact.