Error Message:

When running a query, an error message is returned: Invalid input in field(s): Result Destination (must be a reference to only one non-merged cell)


Resolution:

Ensure the following in the Result Destination field:

1. There are no spaces in your worksheet name.

    For example, the entry is invalid because of the space in POS Data.

2. The worksheet name referenced matches exactly what's entered in the sheet tab (including punctuation).

Cause:

An invalid input could result from various causes. Besides the ones listed in the error message (referencing more than one cell, or referencing a merged cell), an invalid entry can result when:

1. Referencing a worksheet with a space in its name.

2. The worksheet name in the Result Destination field doesn't match the name in the sheets tab.