Share and distribute
Share, present and export workbooks
Share Business Central workbooks in Bitta Sheets at the right access level, present them read-only in a meeting, export to Excel, and move them as packages.
updated: applies-to: 1.0.0.0
Share a workbook to give your team access, present it to walk a meeting through it, and export it to work in Excel or move it to another company.
Share a workbook
- Open the workbook, and in the File menu choose Share. Share Workbook lists who has access and spells out each level.
- Choose who to share with: Share with a Person, Share with a Permission Set or Share with Everyone. When the dialog is narrow, the last ones are under the ... menu.
- For a permission set, search for the set, for example Bitta Apps Sheets - User, and choose it.
- Pick what they can do, and choose OK. The share gets its own row, with its access level.
Access levels
- Can view without print or export only looks at the workbook: no print, export, send or copy. Screenshots of the browser can't be blocked.
- Can view opens, filters, refreshes, prints and exports the workbook.
- Can edit budget amounts only also changes the amounts of budget live data. See Budgets with write-back.
- Can edit also changes the workbook's content and live data.
- Owner also renames, shares and deletes it.
When someone gets access more than one way, for example as a person and through a permission set, the highest level wins.
Change or stop a share
- Change Access brings up the same levels for the selected row.
- Stop Sharing removes the selected share.
- Transfer Ownership hands the workbook to someone else. The old owner keeps Can edit.
On a narrow dialog, Business Central shows Change Access and Stop Sharing under the ... menu. On the Workbooks page, the workbook FactBox shows your access and who has access.
What people with view access see
People you share with at Can view open the workbook read-only, with a smaller ribbon. They can switch between sheet tabs but not change them, refresh the data, and change filters for themselves. Can view without print or export also hides export, print, send and copy.
Present a workbook
In the File menu, choose Present. Present opens the workbook in its own browser tab, full window. The presentation is full screen and read-only, without the ribbon or the formula bar, and the data can still be refreshed. The top line says how to move: click a sheet tab.
Present on the View tab and on the Workbooks page opens it the same way. The expand button on the presentation's title bar shows it in Full Screen.
Export to Excel
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.
If live data is still loading, the export stops: wait for the values, then export again.
Move a workbook with a package
A package moves a workbook's design to another company or environment.
- On the Workbooks page, select the workbook, and in the Actions menu choose Export Package. The package holds the workbook's definitions and the templates it uses, with no business data.
- Where you want it, choose Import Package, and choose the file. Import Workbook Package lists what's inside, for example the workbook and its template.
- Set an action for each line:
- Create adds it.
- Replace Existing overwrites the one that's there.
- Create with New Name adds it under the name you type, for example Sales Dashboard copy.
- Skip leaves it out.
- Choose OK. The message counts what was imported, skipped and failed.
Standard templates can't be replaced, and a workbook shared as Can view without print or export can't be packaged.
When to use it
Share to give your team access, present to walk a meeting through it, and export to work in Excel or move it.