Insert Formulas or Values
Previous  Top  Next


You can specify that data be returned as formulas or values by using the settings interface:

clip0292


Formulas

If you insert formulas, formulas will be returned to the worksheet that contain CDXZipStream™ custom functions. Custom functions provide a dynamic link to the source of data so that data are automatically refreshed whenever the application is opened. Custom functions eliminate the need to repeatedly run CDXZipStream™ settings and are recommended for instances where maintaining a data history is not required. A formula containing the CDXZipCode custom function is shown below:

clip0276


Values

If you insert values, all data will be returned as their actual values and will not contain CDXZipStream™ custom functions. Use this option when you are working with very large data sets, where returning a large number of formulas may impact your worksheet performance. Here is an example of data returned as values:

clip0296