Bitta Sheets · Part 17 · 2:58 · YouTube
Share Business Central Workbooks: Access, Present and Export
What this video covers
Share Business Central workbooks in Bitta Sheets with the right access level, present them in a meeting, and move them.
Share a workbook with a permission set at Can view, see the four access levels, and change access later.
Present a workbook sheet by sheet, export it to Excel, and move its design with Export Package and Import Package.
Transcript
Marcus wants the sales team to see the dashboard, and to walk the plan on Monday. Here's how to share a workbook, present it, and move it.
Open the workbook, here Sales Dashboard. In the File menu, choose Share. Share Workbook spells out each level. Can view opens, filters, refreshes, prints and exports the workbook.
Can view without print or export only looks at it. Can edit budget amounts only also changes budget amounts. Can edit also changes its content and live data. Owners also rename, share and delete it.
To share with a team, open the … menu and choose Share with a Permission Set. Search for the set. Here, Bitta Apps Sheets User. Then pick what the set can do: view without print or export,
view, edit budget amounts only, or edit. Keep Can view, and choose OK. The set gets its own row, with Can view. People you share with at Can view open the workbook read only.
To change the level later, open the … menu and choose Change Access. The same four levels come up. Here, cancel. The … menu also holds Stop Sharing.
To walk the sales plan in a meeting, open the workbook, and in the File menu, choose Present. It opens as a presentation, without the ribbon or the formula bar. The top line says how to move: click a sheet tab.
Click Assumptions for the growth and seasonality behind the plan, then Sales Plan to go back. To work on a copy in Excel, in the File menu, choose Export to Excel.
Formulas stay formulas, live data comes out as values, and charts and cards stay in the workbook. To move the design, select the workbook on the Workbooks page, and choose Export Package in the Actions menu.
The package holds the workbook's definitions and the templates it uses, with no business data. Import Package reads it back. Choose the file, and Business Central lists what's inside:
the workbook and its template. The workbook line is set to Create with New Name. Name it Sales Dashboard copy. Then select the template line, and choose Skip.
Choose OK. Imported 1, skipped 1, failed 0. Use a package to move a workbook to another company or environment. Share to give your team access, present to walk a meeting through it,
and export to work in Excel or move it. Next, organize your workbooks.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping