3305 Main Street Ste 019 Vancouver, WA 98663

Workbook Functions

Office Connector workbook functions behave just like native Excel workbook functions such as SUM() and COUNT().

Advantages

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.

Disadvantages

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:

Write Workbook Function

The following workbook function is available to Office Connector - Write users:

General Workbook Functions