SharePoint Document Issues

How to Link a SharePoint Column to a Cell in an Excel Workbook

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to extract a dynamically changing value from a specific cell inside an Excel workbook and link it to a column in a SharePoint document library.

Product: SharePoint and Microsoft Excel
Device & OS: not provided
Scenario: Tracking project amounts or other metrics where specific values are stored in individual Excel workbooks hosted within a SharePoint library.
Observed behavior: Native SharePoint calculated columns cannot directly pull or read values from cells inside independent Excel workbooks, necessitating an automated workaround.

Before you start

Ensure that the data you want to extract in your Excel workbook is formatted as a structured Table (Insert > Table) and that the file is saved in OneDrive or SharePoint.

Solution 1Recommended

Automate Data Extraction Using Power Automate

Use a Power Automate flow to bridge the gap between individual Excel workbooks and SharePoint document library columns.

Because SharePoint's native calculated columns cannot dynamically pull values directly from cells across multiple independent Excel files, you must use Power Automate.

By setting up a workflow, the system can automatically read the target cell from your Excel Table whenever the file is updated, and subsequently update the SharePoint item metadata.

Format data as an Excel Table

Open your Excel workbook, select the data range containing your target cell, and press Ctrl+T (or navigate to Insert > Table) to format it as a structured table. Save and close the file.

Create a new Power Automate flow

Log into Power Automate and create a new 'Automated Cloud Flow'. Choose the SharePoint trigger 'When a file is created or modified (properties only)' and point it to your document library.

Retrieve the Excel cell value

Add a new action using the Excel Online (Business) connector. Select 'List rows present in a table' or 'Get a row', configure it to point to your SharePoint site, document library, and the specific Table you created in step 1.

Update the SharePoint column

Add another action for SharePoint called 'Update file properties'. Map the Item ID from the trigger step, and insert the dynamic content (the cell value) retrieved from the Excel step into your target SharePoint column field.

Save and test

Save your flow. Open the Excel workbook, change the value in the target cell, save the file, and verify that the SharePoint column updates after the flow finishes running.

Advanced Support: If you encounter specific configuration errors while building your flow, the Microsoft Power Platform Community is an excellent resource for specialized Power Automate troubleshooting.

Free Microsoft Office alternative

Easily Manage Spreadsheets Offline with WPS Office

If you are looking for a lightweight and highly compatible suite to manage your spreadsheets and tables outside of complex SharePoint setups, WPS Office is an excellent free alternative. It offers full support for Microsoft Excel formats and provides a familiar, user-friendly interface.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer for your operating system.
2. Install the application: Run the setup file and follow the simple on-screen instructions to complete the quick installation.
3. Open your spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to instantly view and edit your data tables without complex cloud configurations.

100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight application that runs smoothly on both new and older devicesFamiliar ribbon interface requiring no learning curveFree built-in PDF tools and cross-device document synchronization

microsoft office alternative - wps office

Frequently Asked Questions

Can I use a SharePoint calculated column to read Excel cells directly?

No, SharePoint calculated columns are restricted to referencing other columns within the exact same list or library item. They cannot reach inside a file to parse spreadsheet data.

Why do I need an Excel Table for Power Automate to work?

Power Automate's Excel Online connector requires data to be formatted as a structured Table. This provides precise row and column references that the system can reliably read during automation.

Do I need special permissions to run this flow?

Yes, the user account building and running the Power Automate flow must have read and write permissions to both the SharePoint document library and the specific location where the Excel workbooks are stored.

Will the SharePoint column update in real-time when the Excel cell changes?

It will update automatically, but not instantaneously. Power Automate triggers based on file modification typically process within a few minutes after the Excel file is saved and closed.

Document & File Issues