Skip to content
Bitta Apps

Chapter 1 of 4Page 3 of 3

Before you start

Setup, permissions and the role center

Set up Bitta Sheets in Business Central: the Studio Setup switches, the five permission sets, and where people find their workbooks on the role center.

updated: applies-to: 1.0.0.0

Set up Bitta Sheets once when you roll it out to a finance team: turn it on in Studio Setup, assign the permission sets, and show people where they find their workbooks every day.

Sheets needs no SUPER. It runs with each user's own Business Central permissions.

Studio Setup

Search for Studio Setup and open the Sheets FastTab.

  • Enable Sheets turns workbooks on for people with the Sheets permission sets.
  • Allow AL Formulas and Allow SQL Formulas control the AL and SQL functions in cells. Both only read data.
  • Allow Write-Back lets data tables write changes back to Business Central, after a review. See Live table editing.
  • Max. Rows per Data Table is a safety limit on how many rows one data table loads, here 50,000.
  • Formula Batch Size sets how many function calls go to the server at once, here 500.
Studio Setup Sheets FastTab with Enable Sheets, Allow AL Formulas, Allow SQL Formulas, Allow Write-Back, the row limit of 50,000 and the formula batch size of 500

Turn any of these off, and Sheets tells people that the feature is turned off in Studio Setup.

Write-back also stops with a message when it's turned off for that live data, when the data comes from another company, when the person can only view the workbook, or when they have no permission to change the table in Business Central.

Permission sets

Access comes from five permission sets of its own:

  • Bitta Apps Sheets - User is for everyone who works in workbooks.
  • Bitta Apps Sheets - Admin is for the people who look after them.
  • Bitta Financial Report Metrics, Bitta Financial Metrics Admin and Bitta Financial Report API cover the financial report metrics, the metrics admin and the Financial Report API.
Permission Sets list filtered to Bitta Sheets: Sheets User, Sheets Admin and the three financial report sets

Sheets admins also get the All Workbooks view and can delete any workbook. They still can't open a workbook that isn't shared with them.

Assign the sets to users like any other permission set, and check them whenever someone joins finance.

Find Sheets

Every Sheets page is in Tell Me. Type workbook for Workbooks, Sheet Templates and Sheet Distributions. Recipient lists, the metrics library and the Financial Report API setup are one search away too.

Tell Me search for workbook with Workbooks, Sheet Templates and Sheet Distributions

On the role center, the Sheets & Finance menu holds them all, from Workbooks to New Consolidation.

Sheets and Finance menu with Workbooks, Workbook Folders, Sheet Templates, Sheet Distributions, Recipient Lists and the consolidation pages

In the role center's Apps part, the Sheets tile tells you how to turn Sheets on.

Role center

The headline points to the workbooks shared with you, or suggests building a workbook from live Business Central data.

Activities count your workbooks, the ones shared with you, your favorites and the templates. The New Workbook and Import from Excel tiles start one, and the actions add New Workbook and New Consolidation.

Sheets cues on the role center: My Workbooks, Shared with Me, Favorites and Workbook Templates

Further down, the parts keep your daily workbooks close:

  1. On My Workbook, choose Choose Workbook and pick a workbook. It shows right there, with live data.
  2. My Financial Report shows a financial report, here the balance sheet.
  3. Recent Workbooks and Favorite Workbooks take you back to what you use most.
Choose What to Show dialog for My Workbook with the workbook Sales Dashboard selected
Role center with My Workbook showing a sales dashboard and My Financial Report showing a balance sheet

In the role center's actions, Present and then Present Workbook shows My Workbook full screen and read-only, for a meeting. Present opens the workbook in its own browser tab, full window, and the data can still be refreshed.

When to use it

Set this up once when you roll out Sheets, and check the permission sets whenever someone joins finance. Then start with Workbooks and live data.

Next step

Ready to try Bitta Sheets?