Hiding data source credentials in Excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1525704%22%20slang%3D%22en-US%22%3EHiding%20data%20source%20credentials%20in%20Excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525704%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20loading%20data%20into%20Excel%202016%20from%20an%20Oracle%20server.%20The%20file%20is%20also%20configured%20with%20background%20refresh%20options%20to%20refresh%20the%20data%20every%20minute.%20The%20file%20is%20then%20uploaded%20on%20sharepoint%20to%20be%20shared%20with%20other%20users.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20hide%20Oracle%20server%20and%20user%20credentials%20from%20being%20accessed%20by%20other%20users%3F%20Other%20users%20should%20be%20able%20to%20open%20the%20file%20on%20their%20desktop%20and%20refresh%20the%20connection%20but%20they%20shouldn't%20be%20allowed%20to%20view%20the%20server%20and%20user%20details.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1525704%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

We are loading data into Excel 2016 from an Oracle server. The file is also configured with background refresh options to refresh the data every minute. The file is then uploaded on sharepoint to be shared with other users. 

How can I hide Oracle server and user credentials from being accessed by other users? Other users should be able to open the file on their desktop and refresh the connection but they shouldn't be allowed to view the server and user details. 

 

Thanks!

0 Replies