Document your Excel WorkbookΒΆ

  1. On the Colectica ribbon tab, click the Document Workbook button.

    ../../../_images/document-workbook-button.png

    After clicking the Document Workbook button, Colectica will embed information in your workbook to document your data file and each column. You can add more detailed information by following the steps below.

  2. On the Colectica ribbon tab, click the Data Documentation button to ensure the Data Documentation pane is visible.

    ../../../_images/data-documentation-button.png
  3. Use the Dataset Details tab in the Data Documentation pane to add information about your data file.

    ../../../_images/dataset-details-tab.png
  4. If you add or remove columns, click the Refresh Documentation button in the Dataset Details tab.

    ../../../_images/refresh-documentation-button.png

    The Refresh Documentation button will attach documentation for any new columns you have added, remove information for any deleted columns, and update column names within the documentation.