---
id: video/crDXSPsoIQ8
type: video
title: Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
summary: Editing sales order lines in a spreadsheet inside Business Central with the Advanced Spreadsheets and Reporting app. The demo uses the "Open lines in spreadsheet" action, where a green spreadsheet region stays connected to the sales order and edits update it directly.
tier: community
language: en
tags:
  - spreadsheet editing
  - sales orders
  - advanced spreadsheets app
  - real-time updates
  - line items
  - calculations
  - customer configurations
system: sales
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:18:24.469Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 7326573ab107fb145905e3f36884473b078d1ce8b4cfd5d7d2bd4e00b43768b6
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=crDXSPsoIQ8&t=38s
    title: Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 38
    quote: I can go to actions and say open lines in spreadsheet.
  - kind: video
    url: https://www.youtube.com/watch?v=crDXSPsoIQ8&t=49s
    title: Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 49
    quote: the green region is a spreadsheet region. That means that this region is connected directly to that sales order.
  - kind: video
    url: https://www.youtube.com/watch?v=crDXSPsoIQ8&t=141s
    title: Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 141
    quote: you type in the spreadsheet you work in spreadsheet, but everything behind the scene is always updated directly.
  - kind: video
    url: https://www.youtube.com/watch?v=crDXSPsoIQ8&t=154s
    title: Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 154
    quote: work with configurations or just if there's something related complicated or or if you need to to work on
  - kind: video
    url: https://www.youtube.com/watch?v=crDXSPsoIQ8&t=179s
    title: Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 179
    quote: You can find links below on how to uh install this app in the in the cloud sandbox, free to try.
links:
  learn: []
  objects:
    - object/page/42
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: crDXSPsoIQ8
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=crDXSPsoIQ8
published_at: "2026-09-21T19:14:15.000Z"
duration_s: 195
captions: derived
audience:
  - functional consultant
  - end user
  - administrator
chapters:
  - t: 0
    title: Introduction to spreadsheet editing for sales orders
  - t: 23
    title: Opening sales order lines in spreadsheet
  - t: 49
    title: Working with spreadsheet regions and customer requirements
  - t: 102
    title: Real-time updates and calculations in spreadsheets
  - t: 141
    title: Use cases for spreadsheet editing
  - t: 169
    title: Call to action and availability
features:
  - name: Open lines in spreadsheet
    status: unclear
    t: 38
    verified: false
    status_source: video
  - name: Spreadsheet region connected to sales order
    status: unclear
    t: 49
    verified: false
    status_source: video
  - name: Real-time data synchronization
    status: unclear
    t: 102
    verified: false
    status_source: video
  - name: Edit sales order configurations in spreadsheet
    status: unclear
    t: 141
    verified: false
    status_source: video
objects_mentioned:
  - page Sales order
  - page Sales line
quotes:
  - t: 38
    text: I can go to actions and say open lines in spreadsheet.
    check: exact
  - t: 49
    text: the green region is a spreadsheet region. That means that this region is connected directly to that sales order.
    check: exact
  - t: 141
    text: you type in the spreadsheet you work in spreadsheet, but everything behind the scene is always updated directly.
    check: snapped
  - t: 154
    text: work with configurations or just if there's something related complicated or or if you need to to work on
    check: fuzzy
  - t: 179
    text: You can find links below on how to uh install this app in the in the cloud sandbox, free to try.
    check: exact
---

# Edit Sales Orders in a Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)

> Editing sales order lines in a spreadsheet inside Business Central with the Advanced Spreadsheets and Reporting app. The demo uses the "Open lines in spreadsheet" action, where a green spreadsheet region stays connected to the sales order and edits update it directly.

[Watch on YouTube](https://www.youtube.com/watch?v=crDXSPsoIQ8) · Erik Hougaard · 2026-09-21 · 3:15 · tier community · reviewed (checked by Opus)

## Overview

Erik Hougaard shows how to open the lines of a sales order in a spreadsheet from the Actions menu. The spreadsheet has a green region connected directly to the sales order, so work done in the spreadsheet is written to the order behind the scenes.

He shows that calculations and totals update as line items are edited. He suggests this for complicated cases such as configurations or customer-driven changes. The app requires installation, and links for installing it in a cloud sandbox are given in the video description.

## Key points

- Open a sales order, go to Actions and choose "Open lines in spreadsheet".
- The demo uses the Advanced Spreadsheets and Reporting app for Business Central.
- The green region in the spreadsheet is connected directly to the sales order.
- Edits made in the spreadsheet are updated directly on the sales order behind the scene, which can be checked with Show document.
- Quantities can be linked with formulas (for example two lamps per desk), and calculations such as a sum update as line items are edited.
- Suggested uses: working with configurations, price calculations and other complicated sales order scenarios.
- The app can be installed in a cloud sandbox to try for free, with links below the video.

## Chapters

- [0:00](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=0s) Introduction to spreadsheet editing for sales orders
- [0:23](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=23s) Opening sales order lines in spreadsheet
- [0:49](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=49s) Working with spreadsheet regions and customer requirements
- [1:42](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=102s) Real-time updates and calculations in spreadsheets
- [2:21](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=141s) Use cases for spreadsheet editing
- [2:49](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=169s) Call to action and availability

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| Open lines in spreadsheet | [0:38](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=38s) |
| Spreadsheet region connected to sales order | [0:49](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=49s) |
| Real-time data synchronization | [1:42](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=102s) |
| Edit sales order configurations in spreadsheet | [2:21](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=141s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- [page 42 "Sales Order"](../objects/page/42.md) at [0:23](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=23s)
- page "Sales line" at [1:13](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=73s)

Not found in BC28-30: page "Sales line".

## Quotes

- [0:38](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=38s) "I can go to actions and say open lines in spreadsheet."
- [0:49](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=49s) "the green region is a spreadsheet region. That means that this region is connected directly to that sales order."
- [2:21](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=141s) "you type in the spreadsheet you work in spreadsheet, but everything behind the scene is always updated directly."
- [2:34](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=154s) "work with configurations or just if there's something related complicated or or if you need to to work on"
- [2:59](https://www.youtube.com/watch?v=crDXSPsoIQ8&t=179s) "You can find links below on how to uh install this app in the in the cloud sandbox, free to try."

Presenters (as heard): Eric.