Insert Formulas or Values
Previous  Top  Next

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

insert1

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:

insert2


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:

insert3