Skip to main content

Data Entry

The Data Entry feature allows you to input or update values directly in Excel and write them back to the source data. This is especially useful for budgeting, forecasting, planning, and recording transactions.

The list of available data‑entry sheets is determined by the data model referenced by the NecAccess formula in the selected cell.

When to use Data Entry​

  • Capturing budgets or forecasts: Enter planned values directly in Excel and write them back to the source.
  • Allocating values across dimensions: Distribute inputs across multiple fields in a structured way.
  • Building templates for data collection: Create reusable input sheets for teams or individual contributors.
  • Updating specific fields: Modify targeted values without accessing the source system directly.
  • Performing planning tasks: Write back updated data in real time to support forecasting and scenario modeling.

Perform data entry​

  1. Select a cell that contains a NecAccess formula.
  2. Open the Add-ins tab and select Data Entry.
  3. Choose the sheet you want to use for data entry. Each sheet displays:
    • View ID
    • View Name
    • View Type
  4. Select Ok. The selected sheet opens in your browser.
  5. Use the sheet to analyze, input, or update your data.
  6. (Optional) Select another NecAccess cell that uses the same reference configuration.
    • The Data Entry dialog updates automatically to reflect the new context.
    • After submitting or updating values, related NecAccess formulas in your Excel workbook refresh automatically with the latest data.