28 Handling Time Zone Conversion

Integrated Excel workbooks can be configured to retrieve, edit, and submit data values that represent dates and times. As Excel does not provide native support for managing date or time data when the system time zone changes, ADF Desktop Integration tracks and detects the time zone changes for a workbook.

The add-in informs you about the time zone update when the workbook is opened, and then converts the date-time data of the workbook to the current time zone setting of the system.

For example, assume you are in Arizona (GMT -07:00) and you download data from the server to the integrated Excel workbook, edit the date-time data in the workbook, save the data, but do not upload it. Later, you travel to Seoul and change the time zone preference of your computer to GMT +09:00. When you open the workbook after changing to the Seoul time zone, you receive a message, and then all date-time data values in the integrated parts of the workbook are converted from GMT -07:00 (Arizona) to GMT +09:00 (Seoul).