Create Live Excel in SharePoint Build Live Excel SharePoint

By Grace

Creating a live Excel sheet within SharePoint Online offers numerous advantages, such as real-time collaboration, automatic updates, and instant access for your team. Here's a step-by-step guide on how to achieve this, ensuring your data is always up-to-date and accessible to your team.

Learn How To Create a Sharepoint Online List From an Excel Spreadsheet
Learn How To Create a Sharepoint Online List From an Excel Spreadsheet

To get started, you'll first need to have SharePoint Online and Excel Online as part of your Microsoft 365 subscription. Once you have these, you can follow the steps outlined below to create a live Excel sheet and integrate it into your SharePoint environment.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets

Preparing Your Excel Document

Before you move your Excel file to SharePoint, it's essential to ensure it's ready for collaborative use and can be refreshed automatically.

Post from MyOnlineTrainingHub
Post from MyOnlineTrainingHub

Make sure your Excel file is saved in the cloud, either in OneDrive or SharePoint. You can do this by clicking on 'File' in Excel, then 'Save As', and choosing 'OneDrive - Personal' or your SharePoint site. This will ensure your file is accessible and can be updated automatically.

Setting Up Automatic Refresh

Connect SharePoint List To Excel - Part 2
Connect SharePoint List To Excel - Part 2

To keep your data live and up-to-date, you'll need to set up automatic refresh for your Excel file. This can be done by connecting your Excel file to a data source, such as an SQL database or another Excel file. To do this, click on 'Data' in Excel, then 'Get Data', and choose the data source you want to connect to.

Once you've connected to the data source, you can set up a refresh schedule by clicking on 'Data', then 'Refresh All'. This will bring up a menu where you can choose to refresh the data as frequently as needed - from every minute to every month.

Enabling Simultaneous Editing

Create Your Perfect Budget with Custom Excel & Google Spreadsheet Templates
Create Your Perfect Budget with Custom Excel & Google Spreadsheet Templates

To ensure smooth collaboration, it's crucial to enable simultaneous editing in your Excel file. This feature allows multiple users to edit the same file at the same time, with changes merging automatically.

To enable simultaneous editing, click on 'File' in Excel, then 'Options'. In the left-hand menu, choose 'Save', then scroll down to the 'Save files in this format' section. Choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the drop-down menu. This will ensure that your Excel file is saved in a format that supports simultaneous editing.

Integrating Your Excel Document into SharePoint

Excel How-To: Starting a Basic Spreadsheet
Excel How-To: Starting a Basic Spreadsheet

Once your Excel file is set up for collaboration and automatic refresh, you can integrate it into your SharePoint site for easy access and display.

To integrate your Excel sheet into SharePoint, you can use the 'Excel Web Access' web part. This web part displays your Excel file as a live Web App, allowing users to view and interact with the data without needing to open or edit the file directly.

3 Quick Ways on How To Create A List In Excel!
3 Quick Ways on How To Create A List In Excel!
Get Started With Excel -
Get Started With Excel -
How to Create Professional Looking Excel Spreadsheets
How to Create Professional Looking Excel Spreadsheets
Discover how to enhance your Excel skills by creating a search box that highlights rows! 🔍
Discover how to enhance your Excel skills by creating a search box that highlights rows! 🔍
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets
Unlock Your Productivity With These 141 Free Tools
Unlock Your Productivity With These 141 Free Tools
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
Bookkeeping Spreadsheets, The 5 Best Websites to Download Free Excel Templates 💵
📊 Excel Sikhna Chahte Ho? To Sabse Pehle Iska Interface Samjho!
📊 Excel Sikhna Chahte Ho? To Sabse Pehle Iska Interface Samjho!
How to create a spreadsheet in excel in 5 minutes | excel for beginners
How to create a spreadsheet in excel in 5 minutes | excel for beginners

Adding the Excel Web Access Web Part

To add the Excel Web Access web part to your SharePoint site, navigate to the page where you want to display your Excel file. Click on 'Edit' to enter edit mode, then click on 'Add a web part' in the top right corner of the page. In the list of web parts that appears, scroll down to 'Excel Web Access' and click on it.

This will add the web part to your page. You can then configure the web part by clicking on 'Edit Web Part'. In the menu that appears, you can choose the Excel file you want to display, as well as the range of cells you want to show. You can also customize the appearance of the web part, including the size, layout, and style of the cells.

Viewing and Interacting with the Excel Web Access Web Part

Once your Excel Web Access web part is set up, users can view and interact with the live data in your Excel file. They can sort, filter, and even perform calculations based on the data displayed in the web part.

To enable users to edit the data in the Excel Web Access web part, you can grant them permissions to do so directly in the SharePoint site. This will allow them to make changes to the file without needing to open it in Excel, and the changes will be saved automatically.

With your live Excel sheet now integrated into your SharePoint site, you can enjoy real-time updates, seamless collaboration, and easy access for your team. Regularly check your file's refresh schedule and permissions to ensure it continues to function smoothly and securely. Happy collaborating!"