Dialogue "Edit connection"
The dialogue 
"Edit connection" is the most important dialogue of the GISconnector for Excel. Please read this chapter carefully to understand the functionality of GISconnector for Excel.
"Edit connection" is the most important dialogue of the GISconnector for Excel. Please read this chapter carefully to understand the functionality of GISconnector for Excel.This dialogue consists of the following indexes:
This dialogue can be opened through Excel as well as through ArcGIS by clicking on this button "Edit connection".
"Edit connection".What does it mean when the GISconnector for Excel is managing columns?
If the check box of a column is activated resp. selected in the menu "Columns/Fields", this column is managed by theGISconnector for Excel. This means that the selected column is taken into consideration for the transfer. What do we mean by "taken into consideration"? If the column represents a data source for a transfer, "taken into consideration" means that the column will be transferred.
If the column does not yet exist on the target side and the settings in the tab "Options" were configured that "Those columns not available on the other side are to be created", an activated respectively managed column is newly created on the target side and the content of the source column is transferred to the target column.
What does it mean when a column on the target side is activated or is managed by the GISconnector for Excel?
If a column on the target side is activated resp. managed by the GISconnector for Excel, this column can be deleted when transferring. The requirement is to have configured the settings in the tab "Options" in a way that columns that are not available on the source side but exist on the target side may be deleted there. If a column on the target side is activated or managed by the GISconnector for Excel and if this column either never existed or no longer exists on the source side, then this column will, subject to the Settings, be deleted on the target side in case of transferring.
In summary
An activated column resp. a column that is managed by GISconnector for Excel, can in accordance with the transfer direction, be either a data source or a transfer target. If a column is to be newly produced on the other side, or if data are to be transferred for the column, the column must be activated on the source side resp. managed by the GISconnector for Excel. Whether the column on the trarget side is either activated resp. managed by GISconnector for Excel has no effect on the data transfer.
Whether a column on the target side is activated resp. managed by GISconnector for Excel is only significant in the case when this column is not available on the source side and should be deleted on the target side in the course of the transfer. To put it another way: If a column is not available on the source side and should be deleted on the target side this column must be activated on the target side resp. managed by the GISconnector for Excel.