Skip to content
Bitta Apps

Chapter 2 of 4Page 1 of 12

Workbooks

Workbooks and live data

Create workbooks in Business Central or import them from Excel, organize them in folders, then insert live data tables, reports and charts and refresh them.

updated: applies-to: 1.0.0.0

A workbook is a spreadsheet saved inside Business Central, right next to your data. Start a new one for a report you build from scratch, import the Excel files you already keep, and add live data whenever you want it.

Find your workbooks

In Tell Me, search for Workbooks. The list shows each workbook's folder, your access, when it changed and how many sheets it has. The Details FactBox adds the owner, who has access and the company.

Folders keep your own workbooks together. Open a folder, and the list shows only what is in it. Favorites keeps the workbooks you open most at hand.

Workbooks list in the Finance Pack folder with each workbook's folder, owner, access, modified date and number of sheets

Create a workbook

  1. Choose New Workbook, give it a name, and it opens right away.
  2. Type as you would in any spreadsheet.

The ribbon has the tabs you know: Home, Insert, Formulas, Data, Review and View, plus a Business Central tab for live data. File holds save, rename, import, export, print and share.

File menu of a new workbook with save, rename, new, import from Excel, export, print, share and present
  • More room: switch to the simplified ribbon, or show the tabs only. The classic ribbon brings everything back.
  • Autosave: your work saves itself a few seconds after each change, and the title bar shows Saved. Undo, Redo and Save sit next to the name.
  • Status bar: select some numbers, and it shows their average, count and sum. The slider on the right zooms.

Import from Excel

  1. In Workbooks, choose Import from Excel.
  2. Drop the Excel file on the dialog, or click to browse for it. A file can be up to 20 MB.
  3. The file becomes a new workbook named after it, with its sheets, formulas and formatting.
Import from Excel dialog over the Workbooks list, ready to drop or browse for an Excel file

The import notes bar tells you what did not come along, for example a cell note or a drop-down list. Formulas that point at other sheets keep working.

Imported sales plan with the import notes bar and a formula that reads growth rates from the Assumptions sheet

To add the sheets of an Excel file to the workbook you have open, choose Import from Excel on the File menu or the Data tab instead. Every workbook can be exported back to Excel.

Organize workbooks

An imported workbook starts outside your folders. Choose Move to Folder and pick a folder, and it sits with the rest. Copy makes a copy, and New from Template starts from a saved layout.

Insert live data

In a workbook, choose Insert:

  • Tables: Data table, Connected tables, SQL query.
  • Finance: Financial report, Budget, Journal lines.
  • Documents: Sales document, Purchase document.
  • Analysis: Pivot table, Query, Report data, FlowField series, Date series.
  • Visuals: Chart, KPI card, Image.
  • Page: Print layout.

To change Business Central records from a data table and write them back after a review, see Live table editing.

Each block of live data has a title bar with its name, its row count and when it was refreshed. Choose Refresh all live data to read everything again. Workbook filters, such as a period or a dimension, apply to the live data.

Two live data blocks with title bars showing their name and row count: sales by product line per quarter, and the top three customers with Others

Formulas

Business Central functions are available in formulas, next to the usual spreadsheet functions. AL() and SQL formulas are available when an administrator turns them on in Studio Setup.

Share and present

Share gives other users access, and Present shows the workbook full screen.

Next step

Ready to try Bitta Sheets?