> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pads4.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting to Office 365 Excel

The **Office 365 Microsoft Excel** data provider allows **PADS4** to connect to **Excel documents stored in the cloud** via **SharePoint** or **OneDrive for Business**.

***

### **Steps to Add or Modify an Office 365 Microsoft Excel Connection**

#### **1. Start the Data Provider Wizard**

* Open the **Data Provider Wizard** in **PADS4**.
* Follow the steps for **Adding a Data Provider** or **Editing a Data Provider**.
* Select **Office 365 Microsoft Excel** as the **provider type**.

***

#### **2. Configure Connection Settings**

* **Specify Proxy Settings (If Required)**
  * If your organization uses a **proxy server**, enter the required settings.
  * Contact your **system administrator** for details.

* **Authenticate with Microsoft**
  * Click the **Authenticate** button.
  * A **Microsoft sign-in page** will open.
  * Log in with your **Office 365 credentials** and authorize **PADS4** to access your environment.
  * Once authentication is successful, the **status** will display **successful**.

* **Reauthentication**
  * Each time you edit this **data provider**, you will need to reauthenticate.

Click **Next** to continue.

***

#### **3. Select the Data Source Location**

Choose where your **Excel document** is stored:

* **SharePoint**
* **OneDrive for Business**

**Note:** If your document is stored **locally**, use the **Microsoft Excel data provider** instead.

***

#### **4. Connecting to an Excel Document on SharePoint**

* **Select the SharePoint Site**
  * Click the **Browse** button to open a **site selection window**.
  * Choose the correct **SharePoint site**.

* **Select the Document Library**
  * The first available library is **selected by default**.
  * If needed, choose the correct **library** manually.

* **Select the Excel File**
  * Click **Browse** to locate and select your **Excel document**.

* **Open Excel Document (Optional)**
  * Click **Open Excel document** to preview the file inside a **web browser**.
  * Use this preview to confirm **where the data is located** in the spreadsheet.

Click **Next** to continue.

***

#### **5. Configure Columns and Data Range**

* **Specify Column Names**
  * If the **column names** are in a specific range, check the box for **Column names range**.
  * Enter the **row number** and **column range** containing the column names.
  * If left blank, columns will be named **Column1, Column2, etc.**

* **Select Data Range**
  * If data is in a **specific range**, enter the **start row and start column**.
  * If left blank, **PADS4** will **automatically detect** the data range.
  * Ensure that the **data range does not include column headers**, or they will be treated as data.

* **Preview Data**
  * Click **Preview** to check if the retrieved data is correct.

Click **Next** to continue.

***

#### **6. Finalize the Setup**

* Complete the remaining steps in the **Data Provider Wizard**.
* Click **Finish** to finalize the setup.

***

### **Additional Notes**

* If **authentication fails**, ensure that your **Microsoft 365 account** has the necessary **permissions** to access **SharePoint** or **OneDrive for Business**.
* If your **Excel sheet changes frequently**, verify that your **data range settings** correctly capture the latest data.
* If using a **proxy server**, ensure that **proxy settings** are correctly configured.

This setup allows **PADS4** to retrieve and display real-time **Excel data** from **Office 365** within your **presentations**.