Insert data using MS Excel formula dialog with Caseware Cloud Connector

Note: Your firm administrator must purchase and enable Caseware Cloud Connector for your account.

You can use the Microsoft Excel formula dialog to retrieve and insert data from the engagement file into the excel file.

To insert data using the formula dialog:

  1. Select the formula icon () to launch the Insert Function dialog.

    How to launch the formula dialog.

  2. At the Or select a category field, select SE Connector Develop from the drop-down.

    Select the Cloud Connector category from the list.

  3. Select the desired function.

    If you know the name of the function, you can use the search field to find it. To view all the available functions, see List of Cloud Connector functions.

    In the below example, we selected the CWI.GROUPBALANCE function. Notice that a brief description of the selected function and its parameters display.

    Select the desired function.

  4. Select OK.

  5. If there are parameters associated with the selected function, enter the parameters and select OK.

    The below example shows the parameters associated with CWI.GROUPBALANCE.

    Enter the parameters (if available for the selected function).

Tips:
You can use operators with Cloud Connector formulas to perform calculations.
#BUSY! means that it's taking a few moments to load the data into the cell.
#VALUE! means that the data cannot be found. For example, if the firm address has not been entered, #VALUE! displays in the cell.

Note: Do not forget to save your excel file once you're done. If you want to share a copy of the current excel file and do not want the data to update as the engagement file is updated, you can use the Duplicate & Unlink option. This will create a copy of the spreadsheets that does not include formulas which you can use to backup information or send it to clients. Note that protected sheets cannot be duplicated.