> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.slidehub.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How do Sheets (Excel files) work in SlideHub?

# How do Sheets (Excel files) work in SlideHub?

Sheets are Excel files stored in your company library, next to your slides, documents and PDFs. Your teams open them in Excel, pull individual worksheets into a workbook they're already working in, or download them — always the approved version. A sheet can also act as the data source behind a chart on a slide, so the chart updates whenever you update the numbers.

*Example: your finance team keeps the quarterly figures in one workbook. Anyone building a deck opens it straight from the Excel add-in instead of asking for the file, and the revenue chart on the company overview slide is linked to it, so it redraws itself when the workbook is updated.*

## How do I add a sheet to the library?

Adding sheets is done from the manage view by anyone who can manage your company or team library. Every label in **bold** is exactly what you'll see on screen.

1. Open the manage view and click **Sheets** in the asset list on the left. The **Manage existing company sheets** page opens on the **overview** tab.
2. Click the **add sheets** tab. You'll see the heading **Step 1: Upload sheet(s)** and, under it, **Upload file (.xlsx)**.
3. Drag your file onto the upload area, or click it to browse. The area prompts you with **Drag and drop or select a XLSX file to start the upload**. Sheets are uploaded one at a time, so repeat these steps for each file.
4. At **Add labels**, choose the categories, subcategories and tags for the file, and set any of the options below.
5. Click through to finish. At **All done** the sheet is in the library and your teams can find it.

**Tip:** If your workbook is laid out as an admin-managed placeholder list, SlideHub spots that during the upload and shows you an extra review step before saving. See __What is an admin managed (placeholder) data and how to set it up?__ for what that format looks like.

## What can people do with a sheet?

It depends on where they are.

* **In the browser:** click **Download** to save the file.
* **In the Excel add-in:** click **Open as new** to open the file as a fresh workbook, or **Insert as tab(s)** to pull its worksheets into the workbook they already have open. **Download as XLSX** saves a copy.
* **In Outlook:** click **Attach as XLSX** to attach the file to the email being written. (Please note that files of 20 MB or more can't be attached this way — download the file and attach it yourself instead.)

A sheet isn't placed onto a PowerPoint slide the way a slide or image is. The way Excel data reaches a slide is by linking a chart or table to one of the sheet's worksheets — see __How does linking Excel data to slides work?__

## What can I set on a sheet?

* **High priority:** pushes the file up in your teams' results.
* **Key sheets shortcut:** surfaces the file first for end users, and gives it a shortcut on the Excel add-in's home screen.
* **Hide in explore view:** keeps the file out of the end-user library while you're still preparing it.
* **Disable version warning:** stops SlideHub warning people that they're holding an older copy of this file.

You can also give the sheet categories, subcategories and tags, exactly as you would a slide. Those labels are what your teams filter on, and they also narrow the file picker when someone is linking a chart to a worksheet. See __Structuring Your SlideHub Library__ for how to plan them.

## Which Excel files can I upload?

The file picker offers `.xlsx` files. Macro-enabled `.xlsm` workbooks are also accepted if you drop one in. Anything else is turned away with **Invalid file type - only .xlsx and .xlsm Excel files are supported**.

## How do I tell whether slides depend on a sheet?

Before you replace a workbook, it's worth knowing what is pointing at it.

* Open the sheet in the manage view. If slides depend on it, it's marked **Slides are linked to this Excel file**, and a **Linked slides** panel lists them with a **See all** link.
* For the whole company at once, go to the **Automation** tab and open **Excel Linked Data**. The **Excel files with linked slides** view lists every workbook that feeds a slide and how many slides each one drives.

When you replace a linked sheet with a new version, SlideHub tells you which charts and tables it will keep in sync, and which ones it can no longer match because their worksheet is gone from the new file. Those are unlinked. Renaming or removing a worksheet that a slide points at is the usual cause, so it pays to keep worksheet names stable once something is linked.

## Who can add and see sheets?

Adding, editing and deleting sheets is open to anyone who can manage the library the file lives in — the same permission that covers slides, documents and PDFs. If you can't see the manage view for sheets, ask an account Owner to give you access.

Whether sheets appear at all is a company-level setting rather than a per-person one. On the [**Sheet settings**](https://ppt.slidehub.io/#/asset-settings/sheets) page an account Owner controls two things:

* **Company sheets:** set to **Enabled** to make the sheet library available, or **Disabled** to hide the feature entirely.
* **Restrict sheets to administrators:** set to **Everyone** so all users see sheets, or **Administrators only** to keep the library to administrators while you build it up. Account Owners and Managers keep access either way.

Teams can also switch their own sheet library off independently, so a team that has no use for Excel files isn't shown an empty section.

For the other file types your library holds, see __How do I add content to my company library?__ and __How Documents / Word Files work__.
