Skip to content
Bitta Apps

Bitta Sheets · Part 24 · 2:43 · YouTube

Business Central Sheets Setup, Permissions and Role Center

What this video covers

Set up Bitta Sheets for a finance team: the switches in Studio Setup, the five permission sets, and where people find their workbooks every day.

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

On the role center, show a workbook and a financial report in their own parts, and present a workbook full screen for a meeting.

Transcript

Dana's new analysts start on Monday. Sheets needs to be ready for them. Here's how to set up Bitta Sheets, give people access, and find it every day.

Sheets needs no SUPER. It runs with each user's own Business Central permissions. In Studio Setup, 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.

Max. Rows per Data Table is a safety limit, and Formula Batch Size sets how many function calls go to the server at once. Turn any of these off, and Sheets tells people the feature is turned off

in Studio Setup. Access comes from five permission sets of its own. Sheets User is for everyone who works in workbooks, and Sheets Admin for the people who look after them.

Admins also get an All Workbooks view and can delete any workbook, but they still can't open one that isn't shared with them. The other three cover financial report metrics, the metrics admin, and the Financial Report API.

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.

On the role center, the Sheets and Finance menu holds them all, from Workbooks to New Consolidation. Activities count your workbooks, the ones shared with you, your favorites and templates.

New Workbook and Import from Excel start one. The actions add New Workbook and New Consolidation. Further down, choose a workbook for My Workbook. It shows right here, with live data.

My Financial Report shows a financial report, here the balance sheet. Recent Workbooks and Favorite Workbooks take you back to what you use most. Present Workbook shows My Workbook full screen and read-only,

for a meeting, and the data can still be refreshed. Set this up once when you roll out Sheets, and check the permission sets whenever someone joins finance. Next, the last tutorial: financial metrics and the Financial Report API.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data