In Esri Maps for Office, the enterprise deployment option, CONNECT_TO, does not affect the connection settings.
Last Published: October 12, 2015Esri Maps for Office
Bug ID Number
August 20, 2015
October 9, 2023
Esri Maps for Office
Operating System Version
Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
During the command line update process, you can specify if you want your custom user settings to be overwritten using the parameter FORCEUSERAPPCONFIGUPDATE.
you have set FORCEUSERAPPCONFIGUPDATE=false in your example and that is the reason the "ArcGIS Connection" was not update.
If you want the ArcGIS connection to be updated, please set FORCEUSERAPPCONFIGUPDATE=true in your connection string.
Definition for FORCEUSERAPPCONFIGUPDATE:
When you use Esri Maps for Office for the first time, custom configuration files are written to your roaming directory. These files hold configurations for custom location types, ArcGIS connection settings, and more. These settings are left in place during upgrades to new versions of Esri Maps for Office. To reset these files to the default settings (or the settings specified during the installation), set this parameter to true. By default, this parameter is set to false for silent installations.
As this is an enterprise deployment, the fix must be universal. The file that configures this option is profile specific, and is located in: %userprofile%\AppData\Roaming\Esri Maps Create a login script to run before the installation:1. Open a text editor and copy the following text to the editor: <?xml version="1.0" encoding="utf-8"?><!-- DO NOT EDIT --><!-- For Esri use only --><configuration> <uri> <idn enabled="All" /> <iriParsing enabled="true" /> </uri> <appSettings> <add key="RememberCredentials" value="False" /> <add key="ArcGISConnection" value="<Place your desited Connection string here" /> <add key="LocationLookupBatchSize" value="100" /> <add key="CheckForUpgrades" value="True" /> <add key="UpgradeCheckInterval" value="1" /> <add key="LastCheckForUpgrades" value="08/20/2015 16:07:52" /> <add key="ForceUserAppConfigUpdate" value="False" /> <add key="MapEnrichmentServer" value="<a href="http://la.arcgis.com" target="_blank">http://la.arcgis.com</a>" /> <add key="EsriMapsWebRoot" value="<a href="http://la.arcgis.com" target="_blank">http://la.arcgis.com</a>" /> <add key="OAuthAppId" value="mapsForOffice" /> <add key="Version" value="188.8.131.527" /> <add key="EsriMapsWebProxy" value="/proxy" /> <add key="LastAppConfigUpdate" value="08/20/2015 16:07:52" /> <add key="FallbackToCloudResources" value="False" /> <add key="SoftwareUpgrade" value="False" /> </appSettings></configuration>Ensure the 'ArcGISConnection' value is changed to users’ own ArcGIS Online URL or Portal for ArcGIS URL. 2. Save the file as: ESRI.ArcGIS.Mapping.OfficeIntegration.Excel.dll.config and save the file again as the name: ESRI.ArcGIS.Mapping.OfficeIntegration.PowerPoint.dll.config3. Take the two files and save them in the file share location in Enterprise Software Deployment. (Consult the IT Department. Usually, it is: <a href="file://domain.name/software)" target="_blank">\\domain.name\software)</a>4. Create a 'Log On' script in Group Policy that places the two files in:%userprofile%\AppData\Roaming\Esri Maps The login script runs before the installation is complete. The login script needs to be run only once. If the files are there before the silent install is run, it runs successfully.