Office Connector workbook functions behave just like native Excel workbook functions such as SUM() and COUNT().
One advantage of using workbook functions is that you can place the information exactly where you want it - you are not restricted to a rectangular layout like you are when using QueryTables. Another advantage is that workbook functions are easy to add to an existing spreadsheet without knowledge of SQL and table joins.
The disadvantage of using workbook functions is performance. For large data sets, refreshing your data can be time consuming. If you find that a spreadsheet is starting to take too long to refresh, you can switch to using QueryTables or contact our services department for tips on improving performance.
Query Workbook Functions
The following workbook functions are available to Office Connector - Query users:
"In today's economic times, it is imperative that we are confident in the information we provide to our company and our customers. To achieve this, we rely on Office Connector. Office Connector enables Excel to instantly gather and write information that would otherwise take hours or even days to assemble."