Workbooks
Organize workbooks and sheets
Organize Business Central workbooks in Bitta Sheets with folders, views, favorites and properties, and insert, rename, color, hide or delete sheets.
updated: applies-to: 1.0.0.0
As the workbook list grows, folders, views and favorites keep the ones you need close. Inside a workbook, sheets keep one report together.
Folders
Folders sort your own workbooks. They're personal, so nobody else sees yours, and they're the same in every company.
- On the Workbooks page, choose Show, then Folders. Workbook Folders lists your folders and how many workbooks each one holds.
- Select a folder, for example Finance Pack, and choose New Folder Inside. Name it, for example Budgets 2027, and choose OK. The path shows the nesting: Finance Pack / Budgets 2027.
- New Folder adds a folder at the top level, and Rename renames the selected folder.
- Move and Move to Top Level are under More options, then Actions.
- Delete asks first. The folder's workbooks and folders move up to the folder it was in.
- Show Workbooks, or the folder's name, opens the folder.
Copy a workbook and file it
- In the folder, select a workbook, for example Larkspur Sales Plan, and on the Home tab choose Copy. Name the copy, for example Sales Plan 2027.
- The copy has the same sheets, data tables and filters, and it isn't shared with anyone.
- On the Manage tab, choose Move to Folder, pick the folder, and choose OK.
Workbook Folders now counts the workbook in its new folder.
Show views
The Show tab switches the list between views:
- Workbooks I Can Open lists every workbook you can open.
- My Workbooks lists the ones you own.
- Shared with Me lists the ones others shared with you.
- Favorites lists your favorites.
- Recent lists the workbooks you opened before.
- Templates lists the workbooks marked as templates. See Templates.
- Folders opens Workbook Folders.
Choosing a view reopens the list on it, and every view covers all your folders.
Favorites
Choose the star next to a workbook to make it a favorite, and choose it again to remove it. The Favorites view lists only your favorites.
In the workbook, the star in the title bar shows it's a favorite, and the File menu has Add to favorites, or Remove from favorites when it already is one.
Workbook properties
On the Manage tab, Properties holds the details of the selected workbook:
- Description says what the workbook is for, for example 2027 sales budget by product line.
- Tags help you find it, separated by commas, for example budget, 2027.
- Color gives the workbook a color, as #RRGGBB, for example #2563EB.
- Company stays blank to use the company you work in. Point it at another company, and its live data is read-only.
You can also open or share the workbook from the card, with Open and Share. Changes save when you choose Close.
Rename, delete and open another
- Rename is on the Manage tab of the list, and on the File menu in the workbook.
- Delete is on the Manage tab. It asks first, because it removes the workbook with its sheets, data tables and filters.
- In the workbook, File, Copy this workbook makes a copy and opens it, and Open another workbook opens the list of workbooks you can open.
Sheets in a workbook
All of these are on the Home tab, in the Cells group.
- Insert, then Insert Sheet adds a sheet. The shortcut is Shift+F11.
- Format, then Rename Sheet edits the tab in place: type the name and press Enter.
- Format, then Tab Color gives a tab its own color.
- Format, then Hide Sheet hides the selected sheet. To bring it back, right-click a tab, choose Unhide, and pick the sheet.
- Delete, then Delete Sheet asks first and names the sheet, because it removes the sheet and everything on it. A workbook always keeps at least one sheet.
Sheet names can be up to 31 characters, and each name is used once per workbook.
When someone else saves
Every change saves on its own, and the title bar says Saved. If someone else saves the workbook while you're editing, your edits are kept in a copy named after the workbook with "(your changes)", and This workbook was changed offers Reload to see their changes or Open my copy.
When to use it
Use a folder for each team or year, favorites for the workbooks you open every day, and sheets to keep one report together.