Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Accessing the Longview Add-In For Office

After you have installed the Longview Add-In for Office, the Longview tab appears in the ribbon in Microsoft Excel.

Most Longview Add-In for Office features are unavailable until you connect to a data server. However, if you are not connected to a Longview data server, you can still view the Longview Add-In for Office Help. For more information, see Viewing Longview Add-In for Office Help.

Most of the Longview Add-In for Office functionality is available from the ribbon, which is divided into the following groups:

  • ConnectionsThe Connections group contains all functionality related to connecting to and disconnecting from the data server and managing existing connections.
  • DataThe Data group contains functionality related to data in the Microsoft Excel workbook. For example, you can refresh, lock, or submit data in the active worksheet or workbook, or convert data.
  • InsertThe Insert group contains functionality related to querying data or information from the Longview data server. Click one of the buttons in the Insert group to insert a query into your Microsoft Excel workbook.
  • FormulasThe Formulas group contains functionality related to working with Longview Functions using the Function Arguments dialog. Longview Functions allow you to query different types of data into worksheet cells and submit data from worksheet cells to the Longview data server repository.
  • ViewThe View group contains links to the Data Locks and User Submissions tools:
    • Locks — Opens the Data Locks tool, to view and delete any locks that are applied to the data server repository.
    • Submissions — Opens the User Submissions tool, to view the status of batches that have been created in the system.

    For more information on the Data Locks or User Submissions tools, see the Longview Data Locks Help or Longview User Submissions Help.

  • HelpThe Help group contains a link to the Longview Add-In for Office Help.
Published:

Accessing the Longview Add-In For Office

After you have installed the Longview Add-In for Office, the Longview tab appears in the ribbon in Microsoft Excel.

Most Longview Add-In for Office features are unavailable until you connect to a data server. However, if you are not connected to a Longview data server, you can still view the Longview Add-In for Office Help. For more information, see Viewing Longview Add-In for Office Help.

Most of the Longview Add-In for Office functionality is available from the ribbon, which is divided into the following groups:

  • ConnectionsThe Connections group contains all functionality related to connecting to and disconnecting from the data server and managing existing connections.
  • DataThe Data group contains functionality related to data in the Microsoft Excel workbook. For example, you can refresh, lock, or submit data in the active worksheet or workbook, or convert data.
  • InsertThe Insert group contains functionality related to querying data or information from the Longview data server. Click one of the buttons in the Insert group to insert a query into your Microsoft Excel workbook.
  • FormulasThe Formulas group contains functionality related to working with Longview Functions using the Function Arguments dialog. Longview Functions allow you to query different types of data into worksheet cells and submit data from worksheet cells to the Longview data server repository.
  • ViewThe View group contains links to the Data Locks and User Submissions tools:
    • Locks — Opens the Data Locks tool, to view and delete any locks that are applied to the data server repository.
    • Submissions — Opens the User Submissions tool, to view the status of batches that have been created in the system.

    For more information on the Data Locks or User Submissions tools, see the Longview Data Locks Help or Longview User Submissions Help.

  • HelpThe Help group contains a link to the Longview Add-In for Office Help.
For an optimal Community experience, Please view on Desktop