The following articles can help identify and resolve some commonly found issues when using Office Connector Query:
- Excel 2016 Table Bug
- Why is the Office Connector toolbar disabled?
- Why do my Office Connector functions return no value, zero, or a "#TABLE?" error?
- Why do some numbers appear with very small trailing decimal values?
- Why doesn’t my Office Connector report work after upgrading Sage 300 Construction and Real Estate?
- There was a problem sending the command to the program