--- id: video/5qWLFUqFsi0 type: video title: Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) summary: "Page regions in the Advanced Spreadsheet and reporting app for Business Central: defining regions, tabbed preview mode, one printed page per region, read-only sharing by the owner, and slicers that work on live data. Demonstrated by Eric in a 5-minute video." tier: community language: en tags: - page regions - spreadsheets - reporting app - preview mode - permissions - read-only access - slicers - print functionality - tabs system: reporting review: state: reviewed by: opus at: "2026-10-07T23:18:08.218Z" flags: [] generated: at: "2026-10-07T23:18:08.262Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 80ab8de5e92aaca1fdc1182d3641cf71ebfdc464c8be6bb3f75443dff4961300 evidence: - kind: video url: https://www.youtube.com/watch?v=5qWLFUqFsi0&t=38s title: Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:16.000Z" commit: null t: 38 quote: if we check the regions, we can see that I have four different regions defined - kind: video url: https://www.youtube.com/watch?v=5qWLFUqFsi0&t=133s title: Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:16.000Z" commit: null t: 133 quote: If I now go to preview, the screen changes. And the way it changes is that we have now tabs down here. - kind: video url: https://www.youtube.com/watch?v=5qWLFUqFsi0&t=177s title: Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:16.000Z" commit: null t: 177 quote: every one of these areas becomes a separate page - kind: video url: https://www.youtube.com/watch?v=5qWLFUqFsi0&t=209s title: Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:16.000Z" commit: null t: 209 quote: there always has to be an owner of a spreadsheet but i also got this - kind: video url: https://www.youtube.com/watch?v=5qWLFUqFsi0&t=222s title: Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) date: "2026-09-21T19:14:16.000Z" commit: null t: 222 quote: if I change over here's an in private session. So this is now her access. So she goes to spreadsheet she only sees two links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: 5qWLFUqFsi0 channel: yt-hougaard source_name: Erik Hougaard url: https://www.youtube.com/watch?v=5qWLFUqFsi0 published_at: "2026-09-21T19:14:16.000Z" duration_s: 325 captions: derived audience: - functional consultant - end user - administrator chapters: - t: 0 title: Introduction and app overview - t: 24 title: Spreadsheet demo and regions concept - t: 49 title: Examining existing regions - t: 85 title: Creating a new region - t: 122 title: Preview mode and tab navigation - t: 156 title: Print functionality and region ordering - t: 193 title: Permissions and read-only access - t: 256 title: Slicers and live data comparison - t: 307 title: Call to action and sandbox availability features: - name: Page regions for spreadsheet presentation status: unclear t: 38 verified: false status_source: video - name: Preview mode with tabbed navigation status: unclear t: 133 verified: false status_source: video - name: Print functionality for regions status: unclear t: 166 verified: false status_source: video - name: Spreadsheet permissions and read-only access status: unclear t: 193 verified: false status_source: video - name: Slicers in preview mode status: unclear t: 256 verified: false status_source: video - name: Real-time data in spreadsheets status: unclear t: 282 verified: false status_source: video objects_mentioned: [] quotes: - t: 38 text: if we check the regions, we can see that I have four different regions defined check: exact - t: 133 text: If I now go to preview, the screen changes. And the way it changes is that we have now tabs down here. check: exact - t: 177 text: every one of these areas becomes a separate page check: exact - t: 209 text: there always has to be an owner of a spreadsheet but i also got this check: fuzzy - t: 222 text: if I change over here's an in private session. So this is now her access. So she goes to spreadsheet she only sees two check: snapped --- # Use Page Regions to Present your Reports and Data in Business Central (Advanced Spreadsheets) > Page regions in the Advanced Spreadsheet and reporting app for Business Central: defining regions, tabbed preview mode, one printed page per region, read-only sharing by the owner, and slicers that work on live data. Demonstrated by Eric in a 5-minute video. [Watch on YouTube](https://www.youtube.com/watch?v=5qWLFUqFsi0) · Erik Hougaard · 2026-09-21 · 5:25 · tier community · reviewed (checked by Opus) ## Overview Erik Hougaard shows how to define regions in a spreadsheet so the spreadsheet can be presented as a set of areas. He looks at an example with four regions, creates a new one, and then opens preview mode, where each region shows as a tab at the bottom. He also covers printing, where each region becomes its own page, and permissions, where the owner gives other users read-only access. A user with read-only access sees only the spreadsheets shared with them. Slicers can be used in preview mode, and the data is live from Business Central. The apps are free to use in the cloud sandbox. ## Key points - Regions are defined inside a spreadsheet as screen areas that can have a background color. The demo spreadsheet had four regions. - Tab order follows the ID given to each region (for example, P10 sorted between P1 and P2). - In preview mode, regions appear as tabs at the bottom, and scrolling stays within the current region's area. - When printed, each region becomes a separate page. - A spreadsheet must always have an owner. The owner can grant other users read-only access in Permissions, and those users see only the spreadsheets shared with them. - For a read-only user, clicking edit opens the spreadsheet in preview mode anyway. - Slicers (for example, to pick a date) are still selectable in preview mode, but the spreadsheet cannot be edited there. ## Chapters - [0:00](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=0s) Introduction and app overview - [0:24](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=24s) Spreadsheet demo and regions concept - [0:49](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=49s) Examining existing regions - [1:25](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=85s) Creating a new region - [2:02](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=122s) Preview mode and tab navigation - [2:36](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=156s) Print functionality and region ordering - [3:13](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=193s) Permissions and read-only access - [4:16](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=256s) Slicers and live data comparison - [5:07](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=307s) Call to action and sandbox availability ## Features | Feature | Status | At | |---|---|---| | Page regions for spreadsheet presentation | status not stated, demoed | [0:38](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=38s) | | Preview mode with tabbed navigation | status not stated, demoed | [2:13](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=133s) | | Print functionality for regions | status not stated, demoed | [2:46](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=166s) | | Spreadsheet permissions and read-only access | status not stated, demoed | [3:13](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=193s) | | Slicers in preview mode | status not stated | [4:16](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=256s) | | Real-time data in spreadsheets | status not stated, demoed | [4:42](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=282s) | ## Quotes - [0:38](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=38s) "if we check the regions, we can see that I have four different regions defined" - [2:13](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=133s) "If I now go to preview, the screen changes. And the way it changes is that we have now tabs down here." - [2:57](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=177s) "every one of these areas becomes a separate page" - [3:29](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=209s) "there always has to be an owner of a spreadsheet but i also got this" - [3:42](https://www.youtube.com/watch?v=5qWLFUqFsi0&t=222s) "if I change over here's an in private session. So this is now her access. So she goes to spreadsheet she only sees two" Presenters (as heard): Eric.