When opening a saved QuickBooks Statement Writer (QSW)* report, the error message displays:
Circular Reference Warning, One or more formulas contain a circular reference and may not calculate correctly.
Sometimes the error is followed by:
The customization assembly could not be found or could not be loaded.
Why this is happening
The saved report is most likely damaged.
How to fix it
If the first error is immediately followed by the second error message, please ensure the default save locations for Reports and Templates are on the local C:\ drive. Follow this link to correct that issue.
Since there is no way to fix a damaged QSW report, you need to create a new report.
- From the QSW main screen, Select Design New
- Select the appropriate Report Period and Template(s)
- Give the new report a Name
- Click Next
- Follow the onscreen steps to further customize the report before opening in Excel