Share via

Excel External Data Connection Permission

Zhen Zhang 6 Reputation points
2022-05-11T16:25:28.827+00:00

Hi Experts and Engineers,

I am meeting an issue regarding Excel API connection as Data sources. I am successfully getting data from the web via OData. The permission method is basic authorization, which means a username and password are required.

However, when I shared this file with my non-IT coworkers, the excel required them to enter usernames and passwords. However, this username and password are confidential and cannot be shared.

After testing other APIs, I realized that excel will store the permissions locally. I had an idea that we can get these permission local files so that we can put the files on my coworkers' PC. If so, they would not have to enter usernames and passwords again and the info also won't be exposed.

Does anyone have an idea where the permission files are or a better solution for sharing API data without entering usernames and passwords? Appreciate you!

Best,
Zhen

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,875 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,711 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.