Hi,

  I have a list of account id's in excel and i want to use excel connect query table data to get a bunch of other columns from account table corresponding to the account id's i have. I tried using refresh

This is what I have in excel

    Account Account ID Account Refresh         

    Account ID Account ID Account Name Owner ID

0018000000dglatAAA 

0018000000dgHKLAA2

0018000000dgGXjAAM 

I get the below error

Salesforce: Query()

invalid Range, missing data type, or other error,

type is Account

Object variable or With block variable not set

I am new to using Excel connector. Any help is appreciated.

Thanks