Insert data using MS Excel formula bar 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 bar to retrieve and insert data from the engagement file into the excel file.

To insert data using the formula bar:

  1. Select the formula bar and enter =cwi to display a list of all the available Cloud Connector functions.

    How to display a list of all the available Cloud Connector functions.

  2. Select the desired function and press Tab.

    Tip: If you know the name of the function, type it in the formula bar then press Tab.

    Select the desired functions and press Tab.

  3. If there are parameters associated with the function, enter the parameters as indicated on the screen.

    Perameters indicated by (number, [year_offset])

    Use the formula dialog if you require help on the parameters (what they mean or what is the expected format). It provides on-screen instructions and description.

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 copy the file contents and use the Paste Special | Values option to paste the content in a new excel file. This will ensure that formulas are not included in the new file. For more information, see Paste options.