Object reference not set to an instance of an object

This usually happens when an unexpected value is encountered. There can be several reasons:

  • Make sure you are running the latest releases. I work hard to correct any bugs that appear in the product over time, so the first thing you should do it to check for a new release of the add-in or connectors you are using. This can be done by opening the License wizard.
  • Verify your query or macro selections. Things change over time, so verify that the selections you have made in your queries or macro functions are correct. 
  • Confirm cell references and the values they point to. If you rename a worksheet, you can throw a cell reference in one of the query or macro function wizards out of sync. Turn the Edit Mode off then on again to refresh the little comment triangles in all cells referenced by a query or macro function.