Skip to main content

Link To Formula

Link To Formula inserts a NecLink formula into a cell that works as a dynamic hyperlink. The link is built from the Application Links configured in SEI, which define where each link points and what parameters it needs.

You can reference other cells as parameter values, so the link updates automatically when those cells change. When a user selects the link, it opens the target page in their browser with the correct parameters already applied, whether that is an ERP record, a dashboard, or an external page.

Excel Add-in Link To Formula
  • Open ERP records directly from Excel using a value already in your sheet, such as a customer, invoice, or order number.
  • Open a report or dashboard pre-filtered to the values in your sheet.
  • Create dynamic hyperlinks that update automatically when the referenced cells change.
  • Access external systems such as web pages or custom URLs without leaving Excel.
  1. In the Add-ins tab, select Link To Formula.
  2. Choose the application link from the Link To dropdown.
  3. Define the required parameters. Enter values manually or reference cells to make the link dynamic.
  4. Select Ok. The NecLink formula is inserted into the selected cell.
  5. Select the generated link to open the target page in your browser.

Example​

ExampleOpen GL Detail for an account#
Scenario

You want users to jump directly from Excel into the ERP to review transactions for a specific account and period shown in your sheet.

Details
  1. In the Add-ins tab, select Link To Formula.
  2. In the Link To dropdown, select the GL Detail application link.
  3. Enter the required parameters: Fiscal Year, Period From-To, and Account, either manually or by referencing cells.
  4. Select Ok. A NecLink formula is inserted into the selected cell, opening GL Detail with the parameters you provided.
Keep in mind

Reference cells for the parameters instead of entering values manually. That way the link updates automatically when the account or period changes in your sheet.