OC – Function Types

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.

General Workbook Functions