obrienjimmy
asked on
Enable Data Connections for all users
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???
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???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is there a setup involved in using Group Policy? Or is it on by default?
You will need to install the Office 2007 admt files in Group Policy to set the GPO.
http://www.microsoft.com/en-gb/download/details.aspx?id=22666
http://social.technet.microsoft.com/Forums/en-US/11d09809-951e-46e9-a3df-c6e7dae3d6fe/excel-2007-group-policyexternal-data
http://www.microsoft.com/en-gb/download/details.aspx?id=22666
http://social.technet.microsoft.com/Forums/en-US/11d09809-951e-46e9-a3df-c6e7dae3d6fe/excel-2007-group-policyexternal-data
ASKER
I'm not an admin of the server machine in question. If this isn't already set up, then it's probably not an option for now.
Is there a way I can quickly tell if there is any group policies set up on the machine while logged on as a normal user?
Is there a way I can quickly tell if there is any group policies set up on the machine while logged on as a normal user?
Please ask your server admins / active directory team.
You can do Gpresult on the machine in question
You can do Gpresult on the machine in question
ASKER
Okay, I have it confirmed that the Group Policy setup here comes from a global script, so close to zero chance of doing any modification to that. Thanks anyway, I'll just have to train people to update it on first use.
Old issue, but this is a complete solution for posterity.
The Excel setting is not in the standard Office 2010 or 2013 GPOs from Microsoft. It can be set via a registry setting directly in HKCU Office keys or the HKCU Policies Key. We use ScriptLogic Desktop Authority for user settings, but writing a classic ADM template is easy enough. This is a reg file for what I set for Excel 2010 and 2013 Trust Center External Content:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Softwar
"DataConnectionWarnings"=d
"WorkbookLinkWarnings"=dwo
[HKEY_CURRENT_USER\Softwar
"DataConnectionWarnings"=d
"WorkbookLinkWarnings"=dwo
The Excel setting is not in the standard Office 2010 or 2013 GPOs from Microsoft. It can be set via a registry setting directly in HKCU Office keys or the HKCU Policies Key. We use ScriptLogic Desktop Authority for user settings, but writing a classic ADM template is easy enough. This is a reg file for what I set for Excel 2010 and 2013 Trust Center External Content:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Softwar
"DataConnectionWarnings"=d
"WorkbookLinkWarnings"=dwo
[HKEY_CURRENT_USER\Softwar
"DataConnectionWarnings"=d
"WorkbookLinkWarnings"=dwo
ASKER
Just looking up about Group Policy. Should be able to get that done. Just to clarify, once that is set, it will apply to any Excel document that's opened... not just the one I want to have data connections open for. Is that correct?