Skip to content
Bitta Apps

Chapter 4 of 4Page 4 of 4

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.

File menu of a workbook with Export to Excel, Present and Share

Share a workbook

  1. Open the workbook, and in the File menu choose Share. Share Workbook lists who has access and spells out each level.
  2. 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.
  3. For a permission set, search for the set, for example Bitta Apps Sheets - User, and choose it.
  4. Pick what they can do, and choose OK. The share gets its own row, with its access level.
Share Workbook dialog with the access levels explained, the three-dot menu open with Share with a Permission Set, Share with Everyone, Change Access and Stop Sharing, and the permission set row at Can view

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.
Access level dialog for the Sheets user permission set with Can view without print or export, Can view, Can edit budget amounts only and Can edit

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.

Sales plan presented read-only with the line Presenting: click a sheet tab to move between sheets

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.

  1. 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.
  2. 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.
  3. 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.
  4. Choose OK. The message counts what was imported, skipped and failed.
Import Workbook Package with the workbook set to Create with New Name as Sales Dashboard copy and the template set to Skip
Message Imported 1, skipped 1, failed 0

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.

Next step

Ready to try Bitta Sheets?