GETPIVOTDATA


Description Returns the #N/A error message.

Syntax GETPIVOTDATA (pivot_table, name)
Argument Description
pivot_table The name of the pivot table.
name The name of the cell.

Remarks This function was included only for compatibility with Microsoft Excel, which uses GETPIVOTDATA to return data from a pivot table. Pivot tables are not supported in Formula One for Java.

This function is intended only for users or developers who want to import Excel worksheets that contain Excel's GETPIVOTDATA function. Such worksheets can be opened and saved in Formula One for Java, but the GETPIVOTDATA functionality will not be included.