2.118 FAQ-1053 How to allow changing data when Data Connector is used?

Last Update: 3/8/2021


Data imported by Data Connector is protected by default.

  • Data imported via Text/CSV and Excel Connectors is sortable but not editable.
  • Data imported via Connector types other than Text/CSV and Excel, is neither sortable nor editable.

Editing of Connector Data that is Already Imported

To modify data that has been imported via Connector, click the Connector icon Dadta connector icon connect.png and choose one of the following:

  • Unlock Imported Data: The data remains unlocked until you click the Connector icon and choose Import (at which time, data will be overwritten and edit protections restored).
  • Disconnect Sheet: Removes the connection between the worksheet/matrix and the data source. Also removes edit protections. The connector icon remains allowing you to reconnect to your Data Source (at which time, data will be overwritten and edit protections restored).
  • Remove Data Connector: Permanently remove Data Connectors from all sheets in the active book. Edit protections are removed from all sheets. In addition, remove Exclude Imported When Saving check mark.

Permanently Removing Restrictions on Connector Data

These procedures require changing the default value of LabTalk system variable @IPDC before importing your data.


To allow sorting data imported via Connectors other than Text/CSV or Excel , but still prevent editing:

  1. Select Preference: System Variables....
  2. In the Set System Variables dialog, type "IPDC" in Variable column and "1" in Value .
    Allow edit data by DC.png
  3. Import data by Data Connector.


To allow free-editing and sorting of data imported via any Connector:

  1. Select Preference: System Variables....
  2. In the Set System Variables dialog, type "IPDC" in Variable column and "0" in Value .
  3. Import data by Data Connector.

If you want to remove all restrictions for the current session only, click Window: Script Window, at the prompt type the following, then press Enter:

@IPDC=0

Keywords:import, connect data, CSV, TXT, DAT, Excel, Connector, sort column, sort worksheet, data integrity, data protection,