Forum Discussion

prateekarya1989's avatar
prateekarya1989
Regular Visitor
9 years ago

Unable to see Salesforce Option in Excel 2016

Hi All, I am using Microsoft Office Standard 2016. I want to use PowerQuery option for fetching data from Salesforce to excel but I am unable to see 'Salesforce' option under 'Get & Transform'. Let m...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi prateekarya1989,

 

Have you installed Salesforce Extension? From this blog, we can know that after installing the latest version of Power Query and the Salesforce extension, users see two new sources in the From Other Sources ribbon menu. Based on my test, in Excel 2016, the Salesforce Option is under New Query > From Online Services > From Salesforce..

 

Based on my research, the default setting for Office 2016 is to use TLS 1.0 which has at this point been disabled in most Salesforce Orgs. If you still cannot see this option, please refer to below links to troubleshoot:

64 bit Excel Power Query, Office 2016

The service returned an invalid token. Please contact your IT administrator if this issue persists

 

Besides, your current issue is more related to Salesforce connector and Excel tool, I would suggest you post your question in Salesforce forum and Office forum so that you can get more professional advice.

 

Best regards,
Yuliana Gu

prateekarya1989's avatar
prateekarya1989
Regular Visitor
9 years ago

HI, Can you please share the direct link of the extension as I am unable to find it.

 

Also, I have one doubt.

 

I am using Office Standard 2016. Is that available in same or I need to upgrade to Professional 2016 office.

 

Regards,

Prateek Arya