question

GauravGupta-1893 asked Apr 28, '22 emilyhua-msft edited Apr 29, '22

Accessing Excel QueryTables web url connection with singe signon

I am trying to fill my excel sheet with Excelsheet.QueryTables.Add Method and passing a weburl in connection.

That web url is under Single Sign on. When trying to fill the querytable with refresh method it does not return any data. Can anybody suggest how to access or pass singlesignon credentials to querytables.add method so that weburl got authenticated and data comes out

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft · Apr 29 at 05:46 AM

@GauravGupta-1893

As your is more related to code, but "office-excel-itpro" focuses more on general issue of Excel desktop client, I would modify the tag.
Thanks for your understandings.

0 ·