I have an excel file installed on a server machine that users access through a citrix environment.
This Excel file connects to an Oracle database and displays the results of a select statement. The problem is that every time the file is accessed Data Connections have to be turned on.
I can "Enable all Data Connections" in the Excel Options => Trust Center => External Content so that it doesn't come up anymore, but this is for the logged on account only.
Is there a way I can set this so that every new user wont have to go through this process?? i.e. enable Data Connections on this file for all users???