Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does CDXZipStream™ link directly to a data source?

April 26, 2017Data directly link source

0

Posted

How does CDXZipStream™ link directly to a data source?

1 Answer

0

Posted

• CDXZipStream™ links directly to the data by inserting “Custom Functions” in Microsoft Excel wherever you need data. Custom functions work like Excel formulas and provide a dynamic link to the source of data so that data is automatically refreshed when changes are made. They eliminate the need to repeatedly run CDXZipStream™ settings or manually refresh the data. Just change a zip code or other index manually and the function will update automatically. Should your spreadsheet not update immediately, force a global recalculation in Excel by pressing CTL-ALT-F9.