---
id: video/v4LXW8BO4GQ
type: video
title: Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)
summary: Opening a Business Central financial report as a spreadsheet with "open as a spreadsheet" from Home, using the Advanced Spreadsheets app. It covers slicers, live recalculation, editing, combining reports and distributing spreadsheets that recalculate when opened.
tier: community
language: en
tags:
  - financial reports
  - spreadsheet export
  - advanced spreadsheets
  - live data
  - slicers
  - dimensions
  - report regions
  - excel integration
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:17:55.255Z"
  flags: []
generated:
  at: "2026-10-07T23:17:55.365Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 386777dbe7fd6a19b11cd4d66ba642558ed3401ba45edd2326663ebdd17d5b50
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=35s
    title: Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 35
    quote: So, what we can do instead is that we go to home and say open as a spreadsheet.
  - kind: video
    url: https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=60s
    title: Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 60
    quote: we received a a spreadsheet with the title and there are some slicers, so there's a period slicer, department and a customer group.
  - kind: video
    url: https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=85s
    title: Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 85
    quote: every time you hit this thing or you do something that will otherwise force a recalculation it will get recalculated
  - kind: video
    url: https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=124s
    title: Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 124
    quote: It's still just a spreadsheet on top of that.
  - kind: video
    url: https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=156s
    title: Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)
    date: "2026-09-21T19:14:19.000Z"
    commit: null
    t: 156
    quote: whenever somebody opens this they they will get this calculated
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: v4LXW8BO4GQ
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=v4LXW8BO4GQ
published_at: "2026-09-21T19:14:19.000Z"
duration_s: 201
captions: derived
audience:
  - functional consultant
  - end user
  - administrator
chapters:
  - t: 0
    title: Opening Financial Reports in Spreadsheet View
  - t: 35
    title: Understanding Spreadsheet Structure and Components
  - t: 85
    title: Live Report Calculations and Spreadsheet Functionality
  - t: 124
    title: Formatting and Combining Multiple Reports
  - t: 156
    title: Live Data Updates and Distribution Options
features:
  - name: Open Financial Reports as Spreadsheet
    status: unclear
    t: 0
    verified: false
    status_source: video
  - name: Spreadsheet Slicers for Filtering
    status: unclear
    t: 60
    verified: false
    status_source: video
  - name: Live Report Calculations in Spreadsheet
    status: unclear
    t: 85
    verified: false
    status_source: video
  - name: Spreadsheet Editing and Calculation Capabilities
    status: unclear
    t: 112
    verified: false
    status_source: video
  - name: Combining Multiple Financial Reports
    status: unclear
    t: 124
    verified: false
    status_source: video
  - name: Live Data Distribution to Users
    status: unclear
    t: 156
    verified: false
    status_source: video
  - name: Automatic Date-Based Slicer Updates
    status: unclear
    t: 170
    verified: false
    status_source: video
objects_mentioned: []
quotes:
  - t: 35
    text: So, what we can do instead is that we go to home and say open as a spreadsheet.
    check: exact
  - t: 60
    text: we received a a spreadsheet with the title and there are some slicers, so there's a period slicer, department and a customer group.
    check: exact
  - t: 85
    text: every time you hit this thing or you do something that will otherwise force a recalculation it will get recalculated
    check: fuzzy
  - t: 124
    text: It's still just a spreadsheet on top of that.
    check: exact
  - t: 156
    text: whenever somebody opens this they they will get this calculated
    check: fuzzy
---

# Work with your Financial Reports in a Spreadsheet inside Business Central (Advanced Spreadsheets)

> Opening a Business Central financial report as a spreadsheet with "open as a spreadsheet" from Home, using the Advanced Spreadsheets app. It covers slicers, live recalculation, editing, combining reports and distributing spreadsheets that recalculate when opened.

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

## Overview

Erik Hougaard shows how to open a financial report in Business Central as a spreadsheet instead of exporting a static copy. The spreadsheet has a title and slicers such as period, department and customer group, and the report is calculated live inside it.
He explains that values can be edited and calculated on like in any spreadsheet, and that recalculation happens whenever an action forces it. Several reports can be combined with other data using the advanced spreadsheet app, with formatting. Spreadsheets can be given to other users and calculate with live data when opened. Date slicers update as time passes. The facts mention preview mode.

## Key points

- From Home, choose "open as a spreadsheet" to open a financial report as a spreadsheet.
- The spreadsheet comes with slicers, for example period, department and customer group.
- The report runs as live calculations and recalculates when filters change or an action forces a recalculation, so it is not a static snapshot.
- You can edit values and calculate in the spreadsheet; it is still a spreadsheet on top of the live data.
- Multiple financial reports can be combined with other data in the advanced spreadsheet app, with formatting options.
- Distributed spreadsheets calculate with live data whenever a user opens them.
- Date slicers update automatically over time, so the report stays valid for current and future periods.

## Chapters

- [0:00](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=0s) Opening Financial Reports in Spreadsheet View
- [0:35](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=35s) Understanding Spreadsheet Structure and Components
- [1:25](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=85s) Live Report Calculations and Spreadsheet Functionality
- [2:04](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=124s) Formatting and Combining Multiple Reports
- [2:36](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=156s) Live Data Updates and Distribution Options

## Features

| Feature | Status | At |
|---|---|---|
| Open Financial Reports as Spreadsheet | status not stated, demoed | [0:00](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=0s) |
| Spreadsheet Slicers for Filtering | status not stated, demoed | [1:00](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=60s) |
| Live Report Calculations in Spreadsheet | status not stated, demoed | [1:25](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=85s) |
| Spreadsheet Editing and Calculation Capabilities | status not stated, demoed | [1:52](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=112s) |
| Combining Multiple Financial Reports | status not stated | [2:04](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=124s) |
| Live Data Distribution to Users | status not stated | [2:36](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=156s) |
| Automatic Date-Based Slicer Updates | status not stated, demoed | [2:50](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=170s) |

## Quotes

- [0:35](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=35s) "So, what we can do instead is that we go to home and say open as a spreadsheet."
- [1:00](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=60s) "we received a a spreadsheet with the title and there are some slicers, so there's a period slicer, department and a customer group."
- [1:25](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=85s) "every time you hit this thing or you do something that will otherwise force a recalculation it will get recalculated"
- [2:04](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=124s) "It's still just a spreadsheet on top of that."
- [2:36](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=156s) "whenever somebody opens this they they will get this calculated"

## Disclaimers in the video

- [2:16](https://www.youtube.com/watch?v=v4LXW8BO4GQ&t=136s) preview: in the in preview mode

Presenters (as heard): Eric.